Is this correct use of WITH (NOLOCK, READUNCOMMITTED) in delete?

• john.campbell-1020429

  Ten Centuries

  Points: 1194

  More actions

  November 21, 2011 at 11:58 am

  #1410979

  select * from mytable with (nolock)

  or

  select * from mytable (nolock)

• Brandie Tarvin

  SSC Guru

  Points: 173009

  More actions

  November 21, 2011 at 12:44 pm

  #1411012

  john.campbell-1020429 (11/21/2011)

  ---

  select * from mytable with (nolock)

  or

  select * from mytable (nolock)

  John, go back and re-read the entire thread, please.

  Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.