LISTING A: Statement That Creates and 
Populates the Sample Homework Table

CREATE TABLE dbo.Homework
(
   HomeworkID        int   identity   NOT NULL
                                      CONSTRAINT HomeworkPK
                                            PRIMARY KEY CLUSTERED,
   HomeworkDate    char(10) NOT NULL,
   HomeworkTime   char(12) NOT NULL
)
GO
INSERT INTO dbo.Homework (HomeworkDate, HomeworkTime)
   VALUES ('09_01_2002', '02!33!45.678')
INSERT INTO dbo.Homework (HomeworkDate, HomeworkTime)
   VALUES ('02_27_2000', '17!29!54.163')
INSERT INTO dbo.Homework (HomeworkDate, HomeworkTime)
   VALUES ('12_14_1984', '06!18!29.001')
INSERT INTO dbo.Homework (HomeworkDate, HomeworkTime)
   VALUES ('01_11_1962', '02!18!09.469')
GO
SELECT * FROM dbo.Homework
GO

1