Home Forums Article Discussions Article Discussions by Author Discuss content posted by Rudy Panigas Microsoft SQL Server Error Log Scanning RE: Microsoft SQL Server Error Log Scanning

  • February 14, 2011 at 7:44 am

    #1286487

    abacrotto (2/14/2011)

    I'm sorry for asking something that simple. Why would you use a Cursor and a loop for updating the server when you can use an SQL UPDATE statement instead ?

    This code is much simple and faster than the cursor one.

    What do you think ?

    Regards from Argentina, South America.

    Ariel.

    Thanks Ariel. You are correct, the update command would work better. I should update the code.

    Thanks for comments,

    Rudy

    Rudy