SQLServer数据库开发课程实践一.doc

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 ScenarioIn 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