To all database engineers, when creating stored procedures or functions, you frequently implement repetitive processes (loops), don't you? Loop processing is essential when batch processing large ...

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

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