10/11/2023 0 Comments Sql server cursorI'll take a closer look at each option and explain why it's difficult to pinpoint which is better in terms of performance. ![]() SQL Server 2008 provides a minimal set of tools - cursors and WHILE loops - to accomplish this task. ![]() ![]() There are situations in which you need to individually handle each row in a result set. You should take this approach in most circumstances, as you'll potentially see performance gains when switching from a looping construct to a set-based construct. In a previous TechRepublic column about SQL Server 2005, I showed how you can convert some of your iterative queries (cursors) to set-based operations in order to enhance performance.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |