欢迎来到天天文库
浏览记录
ID:37897988
大小:100.00 KB
页数:8页
时间:2019-06-02
《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
此文档下载收益归作者所有