Home Forums SQL Server 2012 SQL Server 2012 - T-SQL nolock RE: nolock

  • May 17, 2013 at 3:17 am

    #1616090

    mt_dren (5/16/2013)

    See link. http://technet.microsoft.com/en-us/library/ms187373(v=sql.110).aspx

    Note

    For UPDATE or DELETE statements: This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

    I guess, it's applicable if you do INSERT ... SELECT ... FROM table when NOLOCK is used for "from" table.

    I can hardly see how you can update the table/row which will not be locked...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]