Listing 1: Creating and Populating Table T1

SET NOCOUNT ON;
USE tempdb;
GO

IF OBJECT_ID('dbo.T1', 'U') IS NOT NULL
  DROP TABLE dbo.T1;
GO
CREATE TABLE dbo.T1
(
  keycol INT          NOT NULL IDENTITY PRIMARY KEY,
  string VARCHAR(100) NULL
);
INSERT INTO dbo.T1(string) VALUES('12345');
INSERT INTO dbo.T1(string) VALUES('abc');
INSERT INTO dbo.T1(string) VALUES(NULL);
INSERT INTO dbo.T1(string) VALUES('1E3');
INSERT INTO dbo.T1(string) VALUES('12.4');
INSERT INTO dbo.T1(string) VALUES('+123');
INSERT INTO dbo.T1(string) VALUES('-2345');
INSERT INTO dbo.T1(string) VALUES('');
INSERT INTO dbo.T1(string) VALUES('$123');
INSERT INTO dbo.T1(string) VALUES('2147483647');
INSERT INTO dbo.T1(string) VALUES('2147483648');
INSERT INTO dbo.T1(string) VALUES('9223372036854775808');




1