Sql学习......
insert into tbl_SMSendTask (CreatorID,ServiceID,OperationType,sm_Content,OrgAddr,DestAddr,SendType,TaskStatus,FeeType,FeeCode,MsgID)
select '0000',ServiceID,'WAS', '对不起，投票失败，单选或多选请不要出现逗号和数字之外的字符！',inserted.DestAddr,inserted.OrgAddr,'4','0','01','0','0' from inserted
update tbl_Answers set Useable=0 where id=(select id from inserted)
END
else
BEGIN
Insert into tbl_SMSendTask (CreatorID,ServiceID,OperationType,sm_Content,OrgAddr,DestAddr,SendType,TaskStatus,FeeType,FeeCode,MsgID)
select '0000',ServiceID,'WAS', '恭喜您，投票成功，谢谢参与！',inserted.DestAddr,inserted.OrgAddr,'4','0','01','0','0' from inserted
END
6/6 首页 上一页 4 5 6 |
