Advertisement
bisonn

Safe Delete

Oct 21st, 2019
202
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.28 KB | None | 0 0
  1. use MO
  2.  
  3. declare @i bigint = (select max(id) from [_Log_QueryMO] where DateStart<getdate()-7)
  4. set @i = 51700681
  5. set nocount on
  6. set rowcount 100000
  7. set deadlock_priority low
  8. select 1
  9. while @@rowcount>0 begin
  10.     waitfor delay '00:00:00.2'
  11.     delete [_Log_QueryMO] where id<@i
  12. end
  13. go
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement