MSSQL触发器24小时删除
时间:2022-03-14 04:50
ALTER TRIGGER MS_ShoppingCart_Trigger1
ON dbo.MS_ShoppingCart
FOR UPDATE/* INSERT, , DELETE */
AS
delete MS_ShoppingCart
where datediff(dd,MS_CreatDate,getdate())>1
时间:2022-03-14 04:50
ALTER TRIGGER MS_ShoppingCart_Trigger1
ON dbo.MS_ShoppingCart
FOR UPDATE/* INSERT, , DELETE */
AS
delete MS_ShoppingCart
where datediff(dd,MS_CreatDate,getdate())>1