Listing 2: Code That Creates T1 with Three Columns and Populates It with Sample Data
USE tempdb;
SET NOCOUNT ON;
GO
IF OBJECT_ID('T1') IS NOT NULL
  DROP TABLE T1;
GO
CREATE TABLE T1
(
  c1 VARCHAR(10) NOT NULL,
  c2 BIT NOT NULL,
  c3 NUMERIC(12,2) NOT NULL
);
GO
INSERT INTO T1(c1, c2, c3) VALUES('A', 0, 10.00);
INSERT INTO T1(c1, c2, c3) VALUES('A', 0, 10.00);
INSERT INTO T1(c1, c2, c3) VALUES('A', 0, 20.00);
INSERT INTO T1(c1, c2, c3) VALUES('A', 1, 10.00);
INSERT INTO T1(c1, c2, c3) VALUES('B', 0, 10.00);
INSERT INTO T1(c1, c2, c3) VALUES('B', 0, 10.00);
INSERT INTO T1(c1, c2, c3) VALUES('B', 1, 10.00);
INSERT INTO T1(c1, c2, c3) VALUES('B', 1, 20.00);
INSERT INTO T1(c1, c2, c3) VALUES('B', 1, 30.00);
INSERT INTO T1(c1, c2, c3) VALUES('C', 0, 10.00);
INSERT INTO T1(c1, c2, c3) VALUES('C', 0, 10.00);
INSERT INTO T1(c1, c2, c3) VALUES('C', 1, 10.00);