22,209
社区成员
发帖
与我相关
我的任务
分享
CREATE trigger MsgUpdate_Trig
on dbo.MSG_Inbox
for update
as
begin
INSERT dbo.UT_Msg(Sender,MsgType,MsgTitle,MMSUrl,MMSContentLocation,MsgArrivedTime,MMSDownloadedTime,MMSDownloadedState,CommPort)
SELECT Sender,MsgType,MsgTitle,MMSUrl,MMSContentLocation,MsgArrivedTime,MMSDownloadedTime,MMSDownloadedState,CommPort FROM inserted
where MMSDownloadedTime is not null and MMSDownloadedState=100
end