Are Cursors in SQL Server Evil? Part Two: How to Use Cursors in Transact-SQL

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 […]
Read More ›

Are Cursors in SQL Server Evil? Part One: How to Declare Cursors in Transact-SQL

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. […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.