The Database

If you have SQL Server 2000 installed, chances are you have the database that's used for the demos in this section. It's the pubs database that's used. (The pubs database is installed as a sample database by default with a SQL Server 2000 installation.) Because this database is so common, I haven't included any mechanisms to recreate it. The three tables that are used are the authors, publishers, and employees tables.