Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation.

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 ...

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.

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 ...

There is nice spacing and such there. The problem I run into is that that MariaDB is treating the WHILE line, the INSERT, and the VALUES line as one line. Normally, I’d expect this out of SQL ...

While there are a great many books, blogs, and articles out there on T-SQL, there are always a few little "tricks" that many people overlook, or that many authors assume readers know. So this week ...