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

The WHILE loop executes a block of code repeatedly as long as a specified condition is true. While your example is a good introduction, the primary lesson for advanced T-SQL training is that you ...

Dedicated SQL pools in Azure Synapse support the WHILE loop for repeatedly executing statement blocks. This WHILE loop continues for as long as the specified conditions are true or until the code ...