VS2010創(chuàng)建SQL數(shù)據(jù)庫項(xiàng)目入門

1、1.打開VisualStudio2010(確保安裝SQLExpress)新建一個(gè)數(shù)據(jù)庫項(xiàng)目MyDataBase2005。,NETFramework4*Sortby:DeFauHtReoe-ntTenplateSearchBnstalledTemplatesPInstalledTompl試磬VisualC+JOtherLanguagesVisualBfl&icVisualOVisualF-OtherProjectT/pesJDatab日陽丿SQLSerrcrAduancedTecLPvojecESQLServer2005DatabaseProjectOatabBseSQLServerSQLSwi

2、r2005ServerProjectSQLServeir2005VJizard200BDatabaseProject週也ibaseD週肚baseType;DatabaseThisprojertmaybeusedtodefinenSQLServer2005userdatahjise-(akacatalog).U.erdatabasescontainobjectslikeTables,Views,StoredProceduresandIndeueiSQLServer200BSarverProjectDeEabasSQLServerZOOEWizardDatabaseOnlineTr-mplates

3、ame:虹匚adon:MyDataBase2-D05Addto弓口urr日controlSaluti口仃name:Ccth2.主菜單project-addnewitem.,新建一個(gè)表3.在Table2.table.sql中輸入創(chuàng)建表的SQL語句Table2.table.sql-notconnected&CKEATETAELEdbo.曄存總賬-創(chuàng)建表創(chuàng)庫名稱varchar50)KOTKULL,砌料代碼varchar50)KOTKULL,物料名稱varchar(50肌ILL,祜才質(zhì)varchar(50)NULL,規(guī)格varcliar(50)MULL主菜單Tool-ConnecttoDatabase

4、.AddConnectionEnterinformationtoconnecttotheselecteddatasourceorclickChangetochooseadifferentdatasourceand/orprovider.Datasource:MicrosoftSQLServerSqlClientChange.Servername:TR.ereshLogonto-theserveraUeWindoweAuthanticatinUseSQ.LSe-rverAuthenticationUsername:Password:ConnecttoadatabaseaSelectorenter

5、adatabasename:Advanced.TestConnffctioriCancel主菜單Data-Transact-SQLEditor-Connection-Connect,(連接)AntherLticatiotl：Microsoft1SQLServer2008R2Fasswori：RernemlierpassworCoriiLeGt主菜單Data-Transact-SQLEditor-ValidateSQLSyntax（驗(yàn)證語法）鍵盤Ctrl+Shift+E快捷鍵，執(zhí)行上面的SQL語句，創(chuàng)建一個(gè)表8.查看結(jié)果:從SchemaView中可查看生成的表名（庫存總賬），以表的字段名SchemaView仃牛X晶|國雖心曲肉聖JRMyDataBate2005IZ3Assemblies丿LlG-chemasJ用dboTsbl&sJJ彳謎丄_jColumnsa創(chuàng)庫窖稱a酬代碼圍物料名稱H材匿團(tuán)規(guī)格口KeysQjConstraintst口TriggersIndexes=口Statistics-|_JViews.、LJProgrammab