Post reply

Global Cursors

  • May 21, 2015 at 10:28 pm

    #73645

    Comments posted to this topic are about the item Global Cursors

  • May 22, 2015 at 12:30 am

    #1799891

    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.

  • May 22, 2015 at 1:03 am

    #1799900

    Nice one, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • May 22, 2015 at 1:34 am

    #1799911

    Easy, I used a lot in the past, sql 4.2 to sql2000. But there isn't a real need of cursors.

    😀

  • May 22, 2015 at 2:29 am

    This was removed by the editor as SPAM

  • May 22, 2015 at 8:38 am

    #1800032

    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.

  • May 22, 2015 at 9:14 am

    #1800053

    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

  • May 22, 2015 at 10:43 am

    #1800090

    An easy one for a Friday before the long weekend. Thanks, Steve!

  • May 22, 2015 at 11:14 am

    #1800096

    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.

    😛

  • May 23, 2015 at 8:52 pm

    #1800242

    Nice Easy Question. Thnx Steve

    Thanks.

  • May 25, 2015 at 12:08 am

    #1800329

    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

  • May 27, 2015 at 8:24 am

    #1800949

    We still use Cursors for a few things that other methods just don't seem to work.

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply