Home Forums SQL Server 2008 T-SQL (SS2K8) creating SQL login with cursor RE: creating SQL login with cursor

  • January 9, 2013 at 2:26 pm

    #1575448

    Bhuvnesh (1/9/2013)

    paul 77096 (1/9/2013)

    Thats Brilliant, it worked like a dream.

    in future try to avoid cursors instead use loop or set based approach. why ???? google it 🙂

    Cursors VS Loops is an argument that will never be won. a cursor can be faster than a while loop if written correctly. This is one place where a loop or cursor is appropriate as each user needs to be run and is by its nature an RBAR process.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]