首页 > 代码库 > MSSQL触发器24小时删除

MSSQL触发器24小时删除

ALTER TRIGGER MS_ShoppingCart_Trigger1

ON dbo.MS_ShoppingCart

FOR UPDATE/* INSERT, , DELETE */

AS

delete MS_ShoppingCart

where datediff(dd,MS_CreatDate,getdate())>1

MSSQL触发器24小时删除