- 1、本文档共8页,可阅读全部内容。
- 2、原创力文档(book118)网站文档一经付费(服务费),不意味着购买了该文档的版权,仅供个人/单位学习、研究之用,不得用于商业用途,未经授权,严禁复制、发行、汇编、翻译或者网络传播等,侵权必究。
- 3、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。如您付费,意味着您自己接受本站规则且自行承担风险,本站不退款、不进行额外附加服务;查看《如何避免下载的几个坑》。如果您已付费下载过本站文档,您可以点击 这里二次下载。
- 4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等,请点击“版权申诉”(推荐),也可以打举报电话:400-050-0827(电话支持时间:9:00-18:30)。
查看更多
SQLServer数据库开发课程实践一
T-SQL SQL Server DB
Practices Part 1
SQL Server Management Studio
Exercise 1 Exploring the Environment 2
Exercise 2 Creating a New Database 4
Exercise 3 Attaching a Database 5
Exercise 4 Exploring Database 7
Exercise 5 Create Database Objects—Tables, Views 8
Exercise 1Exploring the Environment
ScenarioIn this exercise, you will become familiar with the new SQL Server Management Studio Tool.
SQL Server Management Studio is a new tool built for SQL Server 2005. It combines the functionality of the Enterprise Manager snap-in and the Query Analyzer. Although this is the main tool for administering one or more SQL Servers, you can also use the SQL Server Management Studio for executing queries and scripts, and for managing SQL Server projects.
The SQL Server Management Studio tool is based on the Microsoft Development Environment used in Visual Studio 2005 to create applications. If you are not already familiar with Visual Studio 2005, using the SQL Server Management Studio tool will help you learn to use the new Microsoft Development Environment for Visual Studio 2005.
Tasks Detailed Steps Open SQL Server Management Studio and connect to your server.
From the Windows task bar, select Start | All Programs | Microsoft SQL Server 2005 | SQL Server Management Studio.
When the Connect to Server dialog box appears, verify that Server type is set to Database Engine, Server name is set to localhost, and that Windows Authentication is selected as the authentication method.
Click the Options button to display additional connection options.
Click the Connection Properties tab.
Note that the following options are available:
You can configure the network protocol to use for this connection, which might be different than the protocol you use for other connections.
You can configure a connection timeout, which controls how long to wait for the connection to be made.
You can configure an execution timeout to specify how long to wait for response from a query.
Note that y
文档评论(0)