Leccion De Sql Server 100774A

SQL SERExercise 1: Explore the components and execute queries in SQL Server Management Studio
Task 1: Launch the SQL Server Management Studio
1. In the Lab Launcher, next to 2778A-NY-SQL-01, click Launch.
2. Log on to NYC-SQL-01 as Student using the password Pa$$w0rd.
3. On the Start menu, click All Programs, click Microsoft SQL Server 2008, and then click SQL Server ManagementStudio.
4. The Microsoft SQL Server Management Studio window opens, and then the Connect to Server dialog box appears.
5. In the Connect to Server dialog box, verify that the Server type, Server name, and Authentication fields have been populated correctly, and then click Connect to accept the default settings.
Task 2: Navigate Through Online Help
1. On the Help menu, click Contents.2. The Server 2008 Combined Help Collection - Microsoft Document Explorer window appears.
3. 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: BasicNavigation in SQL Server Management Studio.
4. The Lesson 1: Basic Navigation in SQL Server Management Studio page opens in the right pane.
5. In the Contents pane, expand Lesson 1: Basic Navigation in SQL Server Management Studio, and then click the topic Connecting with Registered Servers and Object Explorer.
6. The content of the page opens in the right pane.
Task 3: Resize, Hide,and Close Object Explorer and Solution Explorer
1. Reduce the size of the Contents pane by resizing it.
2. Scroll down the Connecting with Registered Servers and Object Explorer page to view its contents.
3. Click the Close button to close the Help window.
4. On the View menu, click Solution Explorer.
5. In Solution Explorer, click Auto Hide to hide the pane.
6. In ObjectExplorer, click Auto Hide to hide the pane.
Task 4: Create a New Solution and Explore the Solution Objects in Object Explorer
1. Open Object Explorer by clicking the Object Explorer tab.
2. In Object Explorer, click Auto Hide to dock the pane.
3. In the Object Explorer, expand the Databases folder, double-click AdventureWorks2008, and then double-click Tables.
4. You can scrollthrough the pane to view the list of tables.
5. On the toolbar, click New Query. The SQLQuery1.sql - NY-SQL-01.AdventureWorks2008 window opens.
6. Open Solution Explorer by clicking the Solution Explorer tab.
7. In Solution Explorer, click Auto Hide to dock the pane.
8. In Solution Explorer, right-click Solution 'Solution1', point to Add, and then click New Project.
9. The AddNew Project dialog box appears.
10. In the Templates box, verify that the SQL Server Scripts template is highlighted.
11. In the Name field, select SQL Server Scripts1, type PersonAddress, and then click OK.
12. The PersonAddress project will be created under Solution1.
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 and Create Queries in the Projects
1. In the Connections folder of the PersonAddress project, right-click NY-SQL-01:NY-SQL-01\Administrator, and then click New Query.
2. The SQLQuery1.sql object appears in the Queries folder.
3. In thequery window, type USE AdventureWorks2008.
4. On the toolbar, click Execute.
5. The active database is changed from master to AdventureWorks2008.
6. In the query window, type SELECT DISTINCT CITY FROM Person.Address.
7. Select the query, and on the toolbar, click Execute.
8. The list of cities in the Person.Address table is displayed without repetition in the Results pane....