Global Cursors
-
Comments posted to this topic are about the item Global Cursors
-
Good question for which I has hesitated before finding the good answer.
So thanks for it as I have had to dive in my hidden remembrance as I have not used the cursors since the release of SQL Server 2008 ( maybe because bad experience from the time I was using it with VC++ and Access/ sql server 6.5 ).
I will study the link provided with the answer and maybe I will have some questions.
-
Nice one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
Easy, I used a lot in the past, sql 4.2 to sql2000. But there isn't a real need of cursors.
-
Nice question Steve. I always look for alternatives to cursors but we do still have a few running. I replaced one recently with the lead and lag functions in SQL 2012 and saved myself hours of processing a day. Just haven't had time to rework the others and they run pretty fast since they are looping over small sets.
-
Good question. But the answer doesn't seem to cover all the places a global cursor is available where a local one wouldn't be.
Tom
-
An easy one for a Friday before the long weekend. Thanks, Steve!
-
From where can a global cursor be accessed?
From the unemployment line when it's discovered you're still using cursors, and global ones at that, in this day and age.
-
Nice Easy Question. Thnx Steve
Thanks.
-
TomThomson (5/22/2015)
Good question. But the answer doesn't seem to cover all the places a global cursor is available where a local one wouldn't be.+ 1
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant -
We still use Cursors for a few things that other methods just don't seem to work.
Viewing 11 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply