SQL Server does not have a traditional FOR loop like some other programming languages. However, you can achieve similar functionality using a WHILE loop with a counter variable.

T-SQL Tips -- GO # and WHILE Loops Two quick tricks: populating a table with data quickly, and boosting performance with WHILE loops. By Joshua Jones 07/12/2010 While there are a great many books ...

In this case the query is executed on the server, but it will never complete as it is an infinite loop. In the client, after sending a query for execution, the client waits for an acknowledgement from ...

GO (#) This is very simple. While most of us are familiar with the batch separator 'GO', many don't realize that you can pass a number to it to tell SQL Server to run that preceding batch a ...