[ Home | Contact ]

SQL: Visual QuickStart Guide, 3rd Edition

Creating the Sample Database - SQL Server 2005

To create books in Microsoft SQL Server 2005:

1. On the Windows desktop, choose Start > All Programs > Microsoft SQL Server 2005 > SQL Server Management Studio.
   
   Microsoft SQL Server Management Studio opens.
   
   
2. In the Connect to Server dialog box, select the server and authentication mode; then click Connect.
   
   
3. In Object Explorer (the left pane), navigate to the Databases folder of the server that you're using.
   
   If Object Explorer isn't visible, choose View > Object Explorer (or press F8).
   
   
4. Right-click the Databases folder and choose New Database.
   
   The New Database dialog box opens.
   
   
5. On the General page, type books in the Database Name field; then click OK. (You can use the General, Options, and Filegroups pages to specify other database settings, but the default settings work fine for the sample database.)
   
   SQL Server creates the database books and closes the New Database dialog box.
   
   
6. In Object Explorer, expand the Databases folder and select the database books.
   
   
7. Choose File > Open > File (or press Ctrl+O); navigate to and select the file books_sqlserver.sql; then click Open.
   
   The file's contents appear in a new tab in the right pane.
   
   
8. Choose Query > Execute (or press F5).
   
   SQL Server Management Studio displays the results in the bottom pane. Ignore the messages about nonexistent tables — they're caused by the script's DROP TABLE statements, which you'll need to rerun books_sqlserver.sql later to restore the tables to their original states.
   
   
9. To run SQL scripts and interactive statements against books, see "Microsoft SQL Server" in Chapter 1.

Tip

• The script books_sqlserver.sql differs slightly from the standard SQL script books_standard.sql. In the SQL Server script, the data type of the column pubdate in the table titles is DATETIME (rather than DATE). Also, date literals don't have the DATE keyword. (The standard SQL DATE '2000-08-01' is equivalent to the SQL Server date '2000-08-01', for example.)