To all database engineers, you often implement repetitive processing (loops) using WHILE statements within stored procedures and functions. When batch processing large amounts of data or applying ...

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

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

-- This script calls the SP_WhoIsActive stored procedure 10 times in a loop with a 5-sec delay, storing the result set in a temp table -- and then displaying the results in descending order of ...