Transact-SQL Desk Reference

3.4. CHAPTER LAB EXERCISES

3.4.1. Lab Exercise 1: CREATE TABLE emps3, depts3

Create a test database playdb with some sample data to work with.

(Execute each “SQL:” section separately or add “go” after each to make it a separate batch.)

SQL
/* Create a test database to play in. Omit if you already have one. */ CREATE DATABASE mydb go USE mydb go

Type the following SQL statements into a file, Ch3_emps3_0.sql.

SQL
/* -- ################################################## Ch3_emps3_0.sql */ -------------------####################------------------- ...