SHARE
TWEET

Untitled

a guest Apr 21st, 2017 53 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select * from countries
  2. where visit >= '20110101'
  3.   and visit <= '20111231'
  4.    
  5. BEGIN TRANSACTION T1
  6.  
  7. DELETE
  8. FROM dbo.countries WITH (TABLOCKX)
  9. WHERE visit >= '20110101'
  10.   AND visit <= '20111231'
  11.  
  12. --COMMIT TRANSACTION T1
RAW Paste Data
Top