Tag: sql
Query to delete data before 90 days in 100-100 batches
DECLARE @DELETED_ROWS INT; SET @DELETED_ROWS = 100 WHILE (@DELETED_ROWS > 0) BEGIN WITH cte AS ( SELECT DATEADD(DAY, -90, UPDATEDDATE) AS date, audit_id FROM auditdata ) …
December 19, 2021
Written by: Maurice
DECLARE @DELETED_ROWS INT; SET @DELETED_ROWS = 100 WHILE (@DELETED_ROWS > 0) BEGIN WITH cte AS ( SELECT DATEADD(DAY, -90, UPDATEDDATE) AS date, audit_id FROM auditdata ) …
Hi, I am Maurice. I am From America, At the College of New Shelter,
When I took my first Experimental writing class. In any case, following a couple of short weeks. An auto repairman is a workman with an assortment of vehicle makes or either in a particular territory or in a particular make of car.
December 10, 2024
Millions of people share a passion for cars and football. Having a sturdy car is a must for fans of the sport, whether they are watching …
December 5, 2024
November 26, 2024
November 23, 2024