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