CREATE TRIGGER [十点半包月插入触发器] ON [dbo].[十点半包月]
FOR INSERT
AS
insert ussd_dataout (Send_Time,SocketNo,phone,SME_No,ListNo,Para,Value,Ret_Mode,Fee,Message)
select getdate(),2,十点半包月的字段名,00121,053,null,null,'C','05350500','SMC话单' from inserted
FOR INSERT
AS
insert ussd_dataout (Send_Time,SocketNo,phone,SME_No,ListNo,Para,Value,Ret_Mode,Fee,Message)
select getdate(),2,十点半包月的字段名,00121,053,null,null,'C','05350500','SMC话单' from inserted
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货