34,838
社区成员




create trigger trig_update_transMore
on transMore
for update
as
if update(transDate)
declare @temp_transMoney money,@temp_priID nchar(10),@temp_cardID nchar(10),@temp_transType nchar(10)
select @temp_transMoney=transMoney,@temp_priID=priID ,@temp_cardID=cardID,@temp_transType=transType from inserted
update transInfo
set
transMoney=@temp_transMoney,@temp_cardID=cardID,@temp_transType=transType
where priID=@temp_priID
go