CREATE TABLE RandomLoad([NumberColumn] int,[BitColumn] bit,[VarcharColumn] varchar(20),[CharColumn] char(1),[DateColumn] date)

-- This will populate the RandomLoad table with random records

DECLARE @Loop INT, @Num1 INT, @Length INT

DECLARE @Varchar1 VARCHAR(20)

DECLARE @Varbin1 VARBINARY(128)

DECLARE @Char1 CHAR(2)

DECLARE @Bit1 BIT

DECLARE @Date1 DATE

SET @Loop = 0

WHILE @Loop < 1000 -- number of records to generate

BEGIN

   -- Generate Number

   SET @Num1 = ROUND(RAND() * 10000, 0)

   -- Generate Bit

              SET @Bit1 = CRYPT_GEN_RANDOM(1)%2

   -- Generate Varchar

   SET @Varchar1 = ''

              SET @Length = CAST(RAND() * 20 AS INT) -- Up to 20 characters long

              WHILE @Length <> 0

              BEGIN

                     SET @Varchar1 = @Varchar1 + CHAR(CAST(RAND() * 96 + 32 AS INT))

                     SET @Length = @Length - 1

              END

   -- Generate Char

              SET @Char1 = LEFT(newid(),1)

   -- Generate Date

   SET @Date1 = CAST(GETDATE() +(365 * 2 * RAND() - 365) AS DATE)

   INSERT INTO [RandomLoad] VALUES (@Num1,@Bit1,@Varchar1,@Char1,@Date1)

   SET @Loop = @Loop + 1

END

GO