Scripts SQL Divers

SCRIPT SELECTIONNE :

N2 Script - Purge de la table MESSAGE.sql


-- Purge de la table Tars Messages via SSMS
-- Saisir la date de fin de purge (format AAA-MM-JJ)
-- Commencer le traitement de 10 en 10 puis augmenter a 100 puis 1000 (ne pas aller trop vite)

WHILE EXISTS(SELECT 1 FROM [dbo].[TARS_MESSAGES] where [CMSG_DATE_CREA]<'2018-01-01')
BEGIN
BEGIN TRANSACTION
DELETE FROM [dbo].[TARS_MESSAGES]
WHERE [CMSG_ID] IN (SELECT TOP 10 [CMSG_ID] FROM [dbo].[TARS_MESSAGES] where [CMSG_DATE_CREA]<'AAAA-MM-JJ' )
COMMIT TRANSACTION
checkpoint
END;