Listing 1: T-SQL to Generate and Populate a Table

Alter Procedure make_table1_by_sa
As
IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
	WHERE TABLE_NAME = 'table1')
DROP TABLE table1

CREATE TABLE table1
(
myid 	   int 		NOT NULL	IDENTITY(2,2) 
	   PRIMARY KEY,
fname    varchar(20)	NOT NULL,
lname	   varchar(40)	NOT NULL,
pubname  varchar(100)	NOT NULL,
email	   varchar(255)	NOT NULL
)
INSERT table1 (fname, lname, pubname, email) 
	Values ('Mark','Smith','SQL Server Mag','mark@sqlmag.com')
INSERT table1 (fname, lname, pubname, email) 
	Values ('Karen','Forster','SQL Server Mag','karen@sqlmag.com')