好象不用判断直接delete就可以吧
AS
BEGIN
delete
FROM Sellrecord S where S.MYDATE in (select s.MYDATE
FROM Sellrecord s join inserted i
ON datediff(day,-s.MYDATE,getdate())=1)
END
AS
BEGIN
delete
FROM Sellrecord S where S.MYDATE in (select s.MYDATE
FROM Sellrecord s join inserted i
ON datediff(day,-s.MYDATE,getdate())=1)
END
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货