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.
April 21, 2024
Introduction When you hear the word “diamond,” do you picture a sparkling white stone, or perhaps something more colorful? Pink diamonds have become increasingly popular due …
April 18, 2024
April 18, 2024