WEB LISTING A: Script That Creates 
the Table T1 with 100 Columns

IF OBJECTPROPERTY(OBJECT_ID('dbo.T1'), 'IsUserTable') = 1
  DROP TABLE dbo.T1
GO

DECLARE
  @cmd AS nvarchar(4000),
  @i   AS int

SET @cmd =
  N'CREATE TABLE dbo.T1(key_col int NOT NULL
 IDENTITY(1, 1) PRIMARY KEY'

SET @i = 1
WHILE @i <= 100
BEGIN
  SET @cmd =
    @cmd + N',col' + CAST(@i AS nvarchar(10)) +
    N' int NOT NULL DEFAULT 0'
  SET @i = @i + 1
END

SET @cmd = @cmd + N')'

EXEC sp_executesql @cmd

INSERT INTO T1 DEFAULT VALUES

SELECT * FROM T1