Home Forums SQL Server 2008 SQL Server 2008 - General s there any difference in using cursor and table? RE: s there any difference in using cursor and table?

  • November 9, 2012 at 2:25 am

    #1557503

    Koen Verbeeck (11/8/2012)

    sumith1andonly1 (11/8/2012)

    is it possible to fetch multiple columns (using cursor)

    Let's be clear here:

    cursors are sloooooooooooow.

    Only use them if you have a very good reason to use them.

    Yes, I agree. Cursors are slow because they do row by row transactions instead of set based transactions which are much much much faster than row by row transactions.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉