Click to See Complete Forum and Search --> : For loop in SQL


johnsonlim026
November 1st, 2006, 06:46 PM
Does SQL support For loop?Cause i fail to find any syntax for for loop in Help for SQL server.Can anyone tell me?

Alsvha
November 2nd, 2006, 03:52 AM
I think you'll need to use WHILE loops

exterminator
November 5th, 2006, 05:07 AM
http://www.sqlteam.com/item.asp?ItemID=5761

johnsonlim026
November 5th, 2006, 07:14 PM
Thanks all...Solved using WHILE loop