Are Cursors in SQL Server Evil? Part Two: How to Use Cursors in Transact-SQL
May 8,
2015
In the previous installment, we looked at the numerous options for declaring a cursor. All that remains is the easy part: fetching data from a cursor. To do this, we shall have to declare variables for each of the columns of the cursor. For purposes of clarity and ease of understanding, I see no reason […]
Are Cursors in SQL Server Evil? Part One: How to Declare Cursors in Transact-SQL
May 6,
2015
Henry K., from Learning Tree’s class Developing High Performance SQL Server Databases, writes “My sysadmin said that cursors are evil, and I should never use them in my stored procedures. Is this true?” Henry: Cursors are just another tool in the T-SQL toolbox, and like any tool they can be used properly or used poorly. […]