Guest User

Untitled

a guest
Apr 24th, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. private static void CleanAbc()
  2. {
  3. using (var sql = Program.Connection())
  4. {
  5. sql.Execute(@"
  6. declare @expiration datetime = DATEADD(DAY, -21, cast(GETDATE() AS DATE));
  7.  
  8. with topfew as (select top 100000 * from abc with(paglock)
  9. WHERE [time] < @expiration)
  10. delete topfew;
  11.  
  12. set @expiration = DATEADD(MONTH, -6, cast(GETDATE() AS DATE));
  13.  
  14. with topfew as (select top 100000 * from abc with(paglock)
  15. WHERE [time] < @expiration)
  16. delete topfew;
  17. ", commandTimeout: 60 * 60 * 12);
  18. }
  19. }
Add Comment
Please, Sign In to add comment