SQLServer数据库开发课程实践一

《SQLServer数据库开发课程实践一》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、T-SQL&SQLServerDBPracticesPart1SQLServerManagementStudioExercise1ExploringtheEnvironment2Exercise2CreatingaNewDatabase4Exercise3AttachingaDatabase5Exercise4ExploringDatabase7Exercise5CreateDatabaseObjects—Tables,Views8Exercise1ExploringtheEnvironmentScenarioInthisexercise,youwillbecomefamiliarwitht

2、henewSQLServerManagementStudioTool.SQLServerManagementStudioisanewtoolbuiltforSQLServer2005.ItcombinesthefunctionalityoftheEnterpriseManagersnap-inandtheQueryAnalyzer.AlthoughthisisthemaintoolforadministeringoneormoreSQLServers,youcanalsousetheSQLServerManagementStudioforexecutingqueriesandscripts,

3、andformanagingSQLServerprojects.TheSQLServerManagementStudiotoolisbasedontheMicrosoftDevelopmentEnvironmentusedinVisualStudio2005tocreateapplications.IfyouarenotalreadyfamiliarwithVisualStudio2005,usingtheSQLServerManagementStudiotoolwillhelpyoulearntousethenewMicrosoftDevelopmentEnvironmentforVisu

4、alStudio2005.TasksDetailedSteps1.OpenSQLServerManagementStudioandconnecttoyourserver.1.FromtheWindowstaskbar,selectStart

5、AllPrograms

6、MicrosoftSQLServer2005

7、SQLServerManagementStudio.2.WhentheConnecttoServerdialogboxappears,verifythatServertypeissettoDatabaseEngine,Servernameissettolocalhost,andthat

8、WindowsAuthenticationisselectedastheauthenticationmethod.3.ClicktheOptionsbuttontodisplayadditionalconnectionoptions.4.ClicktheConnectionPropertiestab.Notethatthefollowingoptionsareavailable:§Youcanconfigurethenetworkprotocoltouseforthisconnection,whichmightbedifferentthantheprotocolyouuseforotherc

9、onnections.§Youcanconfigureaconnectiontimeout,whichcontrolshowlongtowaitfortheconnectiontobemade.§Youcanconfigureanexecutiontimeouttospecifyhowlongtowaitforresponsefromaquery.Notethatyoucanexportyourserverregistrationinformation,orimportregistrationinformationfromanotherserver.Thisfacilitycanbevalu

10、ableforlargeorganizationswithmanySQLServeradministratorswhoallwanttohavethesameserversregistered.5.ClickOptionsagaintohidetheadditionaloptionstabs.6.ClickConnect.NotethevariousareasoftheSQLServerManagementS