Explore related questions sql-server-2008 cursors See similar questions with these tags.

The 'Best Practice' of avoiding cursors in SQL Server dates back to SQL Server 2000 and earlier versions. The rewrite of the engine in SQL 2005 addressed most of the issues related to the …

Aug 1, 2019 · Using SQL 2005 / 2008 I have to use a forward cursor, but I don't want to suffer poor performance. Is there a faster way I can loop without using cursors?

Dec 22, 2021 · 71 I knew of some performance reasons back in the SQL 7 days, but do the same issues still exist in SQL Server 2005? If I have a resultset in a stored procedure that I want to act upon …

Another option in SQL Server is to do all of your dynamic querying into table variable in a stored proc, then use a cursor to query and process that. As to the dreaded cursor debate :), I have seen studies …

Jan 18, 2017 · 1 I have the following query, I want use a nested cursor in my query. How to do this, because it's not running and I am new to SQL Server. Please help me

Then subsequent runs fail when it tries to create cursors since a cursor with the name already exists. Is there a way I can query which cursors exists and if they are open or not so I can close and …

Question about use of Cursors in combination with RETURN in a SQL Server 2008 Stored Procedure Consider this example: CREATE PROCEDURE [dbo].[test] @ReturnEarly BIT = 0 AS BEGIN SET …

Oct 24, 2019 · I agree with others -- cursors are necessary sometimes, but should be avoided whenever possible. SQL is designed and optimized to operate on sets. Nothing in the (very simplified) function …

Feb 11, 2016 · The error will occur in the nested stored procedure when it attempts to open "cur". Run this bit of sql to see your CURSOR_DEFAULT: