Ejercicio De Sql Server 2008

Lab: Using SQL Server Management Studio and SQLCMD

L1-1

Module 1: Getting Started with Databases and Transact-SQL in SQL Server 2008

Lab: Using SQL Server Management Studio and SQLCMD
Exercise 1: Explore the components and execute queries in SQL Server Management Studio
Task 1: Launch the SQL Server Management Studio
1. 2. 3. 4. 5. In the Lab Launcher, next to 2778A-NY-SQL-01, clickLaunch. Log on to NYC-SQL-01 as Student using the password Pa$$w0rd. On the Start menu, click All Programs, click Microsoft SQL Server 2008, and then click SQL Server Management Studio. The Microsoft SQL Server Management Studio window opens, and then the Connect to Server dialog box appears. In the Connect to Server dialog box, verify that the Server type, Server name, and Authentication fieldshave been populated correctly, and then click Connect to accept the default settings.

Task 2: Navigate through online help
1. 2. 3. On the Help menu, click Contents. The Server 2008 Combined Help Collection - Microsoft Document Explorer window appears. In the Contents pane, navigate to SQL Server Books Online | Getting Started | Initial Installation | Overview of SQL Server Installation |Features and Tools Overview |SQL Server Studios Overview | Introducing SQL Server Management Studio | Tutorial: SQL Server Management Studio | Lesson 1: Basic Navigation in SQL Server Management Studio.

L1-2

Lab: Using SQL Server Management Studio and SQLCMD

4. 5.

The Lesson 1: Basic Navigation in SQL Server Management Studio page opens in the right pane. In the Contents pane, expand Lesson1: Basic Navigation in SQL Server Management Studio, and then click the topic Connecting with Registered Servers and Object Explorer. The content of the page opens in the right pane.

6.

Task 3: Resize, hide, and close Object Explorer and Solution Explorer
1. 2. 3. 4. 5. 6. Reduce the size of the Contents pane by resizing it. Scroll down the Connecting with Registered Servers and ObjectExplorer page to view its contents. Click the Close button to close the Help window. On the View menu, click Solution Explorer. In Solution Explorer, click Auto Hide to hide the pane. In Object Explorer, click Auto Hide to hide the pane.

Task 4: Create a new solution and explore the solution objects in Object Explorer
1. 2. 3. 4. 5. 6. 7. 8. 9. Open Object Explorer by clicking the Object Explorertab. In Object Explorer, click Auto Hide to dock the pane. In the Object Explorer, double-click the Databases folder, double-click AdventureWorks2008, and then double-click Tables. You can scroll through the pane to view the list of tables. On the toolbar, click New Query. The SQLQuery1.sql - NY-SQL01.AdventureWorks2008 window opens. Open Solution Explorer by clicking the Solution Explorer tab.In Solution Explorer, click Auto Hide to dock the pane. In Solution Explorer, right-click Solution 'Solution1' (1 project), point to Add, and then click New Project. The Add New Project dialog box appears.

Lab: Using SQL Server Management Studio and SQLCMD

L1-3

10. In the Templates box, verify that the SQL Server Scripts template is highlighted. 11. In the Name field, select SQL ServerScripts1, type PersonAddress, and then click OK. 12. The PersonAddress project will be created under Solution ‘Solution1’ (1 project). 13. In Solution Explorer, in the PersonAddress project, right-click Connections, and then click New Connection. 14. The Connect to Server dialog box appears. Verify the connection information, and then click OK.

Task 5: Add projects to an existing solution andcreate queries in the projects
1. 2. 3. 4. 5. 6. 7. 8. 9. In the Connections folder of the PersonAddress project, right-click NY-SQL01:NY-SQL-01\Student, and then click New Query. The SQLQuery1.sql object appears in the Queries folder. In the query window, type USE AdventureWorks2008, and then press ENTER. On the toolbar, click Execute. The active database is changed to AdventureWorks2008. In the...