60 likes | 76 Vues
Lab 1 Using Query Analyzer. CISB224 & CCSB244 Semester 1, 2007/2008. Select Microsoft SQL Server 7.0 from All Programs Launch Query Analyzer Specify SQL Server: coe-student-01 Use SQL Server Authentication: Login Name: ccsb0607 Password: ccsb0607 Click OK. Select DB: Northwind.
E N D
Lab 1 Using Query Analyzer CISB224 & CCSB244 Semester 1, 2007/2008
Select Microsoft SQL Server 7.0 from All Programs • Launch Query Analyzer • Specify SQL Server: coe-student-01 • Use SQL Server Authentication: • Login Name: ccsb0607 • Password: ccsb0607 • Click OK
Enter the following query: SELECT * FROM Products • Click the Execute Query button
Exercise • Open the file nothwindtables.bmp • Study the tables in Northwind • Discuss the following: • What kind of business is Northwind Traders in? • What information can Northwind Traders obtain from its database?