1. DECLARE @intFlag INT
    SET @intFlag = 1
    WHILE (@intFlag <=28)
    BEGIN
    UPDATE 'TABLE NAME'
    SET 'Column Name' = '000000' -- Note: Column Name that you want to update.
    WHERE ('Column ID' = @intFlag) -- Note: Unique Column ID of TAble
    SET @intFlag = @intFlag + 1
    END
    GO
    0

    Add a comment

Subscribe
Subscribe
Favorite Links
Blog Archive
About Me
Loading
Dynamic Views theme. Powered by Blogger. Report Abuse.