Home Forums Article Discussions Article Discussions by Author Discuss content posted by bitbucket T-SQL Performance 1 RE: T-SQL Performance 1

  • February 17, 2012 at 1:43 am

    #1448319

    I have a table containg a large number

    DECLARE @int INT;

    SET @int = 1;

    WHILE @int <=1000

    BEGIN

    INSERT INTO TestTable (id, col)

    VALUES (@int, 'name' + CAST(@int AS VARCHAR(100)));

    SET @int += 1;

    I Have Nine Lives You Have One Only
    THINK!