Friday, February 15, 2013

MS SQL server cursor

DECLARE @number INT,
        @date DATETIME

DECLARE cur_name CURSOR FOR
    SELECT RAND()*100,GETDATE()
OPEN cur_name
    FETCH NEXT FROM cur_name INTO @number,@date
WHILE @@FETCH_STATUS = 0
    BEGIN
        PRINT CAST(@number AS VARCHAR)+'/'+CAST(@date AS VARCHAR)
       
        --- statement for do something
        --- statement for do something
  
        FETCH NEXT FROM cur_name INTO @number,@date
    END
CLOSE cur_name
DEALLOCATE cur_name

No comments:

Post a Comment