Listing 1: Creating and Populating Tables T1 and T2

SET NOCOUNT ON;
USE tempdb;
GO
IF OBJECT_ID('dbo.T1') IS NOT NULL
  DROP TABLE dbo.T1;
GO
IF OBJECT_ID('dbo.T2') IS NOT NULL
  DROP TABLE dbo.T2;
GO

CREATE TABLE dbo.T1
(
  keycol INT          NOT NULL,
  val    VARCHAR(100) NOT NULL
);

INSERT INTO dbo.T1(keycol, val)
   VALUES(1, '10');
INSERT INTO dbo.T1(keycol, val)
   VALUES(2, 'abc');

CREATE TABLE dbo.T2
(
  keycol INT NOT NULL
);

INSERT INTO dbo.T2(keycol) VALUES(1);
INSERT INTO dbo.T2(keycol) VALUES(10);
INSERT INTO dbo.T2(keycol) VALUES(11);
GO