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, ...
In SQL Server, a cursor is a database object that allows you to process the rows of a result set one at a time. This is in contrast to standard T-SQL operations, which typically work on entire sets of ...
# Using T-SQL loops for dedicated SQL pools in Azure Synapse Analytics Included in this article are tips for dedicated SQL pool solution development using T-SQL loops and replacing cursors. ## Purpose ...