22,300
社区成员




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