Skip to content

Instantly share code, notes, and snippets.

@xavierzwirtz

xavierzwirtz/gist:f15cb9d61b9ced50e826e69571ed8b5b

Last active August 7, 2020 18:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save xavierzwirtz/f15cb9d61b9ced50e826e69571ed8b5b to your computer and use it in GitHub Desktop.
Save xavierzwirtz/f15cb9d61b9ced50e826e69571ed8b5b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
-- run this for both tables
-- BDTriggerAuditBDPageHits
-- BDTriggerAuditBDCarts
SET NOCOUNT ON;
DECLARE @r INT;
SET @r = 1;
WHILE @r > 0
BEGIN
BEGIN TRANSACTION;
DELETE TOP (1000) from
dbo.BDTriggerAuditBDCarts
WHERE AuditTime < '2020-7-1'
SET @r = @@ROWCOUNT;
COMMIT TRANSACTION;
END
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment