/****** 对象: 触发器 dbo.Trigger_SynTradeTypeForInsertOrUpdate 脚本日期: 2007-3-4 21:33:23 ******/
Create TRIGGER Trigger_SynTradeTypeForInsertOrUpdate
ON trade
FOR Insert,Update
AS BEGIN TRAN
update Trade set T_Type=(case T_Direction when '供应'then 1 when '求购' then 2 when '合作' then 3 when '代理' then 3 when '合作代理' then 3 when '转让' then 3 else 1 end )
where T_ID in (select T_ID from inserted) update Trade set F1=a.C_Client
from [Company] a
inner join [Trade] p on (p.T_C_ID=a.C_ID) and (a.C_Client>0) and (p.T_ID in(select T_ID from inserted)) IF (@@ERROR <> 0)
Begin
ROLLBACK TRAN
RAISERROR ('同步数据时出错!', 16, 1)
Return
End
COMMIT TRAN 如果是sql2005,
可以用TransactionScope
http://blog.csdn.net/fanweiwei/archive/2007/05/21/1619241.aspx
Create TRIGGER Trigger_SynTradeTypeForInsertOrUpdate
ON trade
FOR Insert,Update
AS BEGIN TRAN
update Trade set T_Type=(case T_Direction when '供应'then 1 when '求购' then 2 when '合作' then 3 when '代理' then 3 when '合作代理' then 3 when '转让' then 3 else 1 end )
where T_ID in (select T_ID from inserted) update Trade set F1=a.C_Client
from [Company] a
inner join [Trade] p on (p.T_C_ID=a.C_ID) and (a.C_Client>0) and (p.T_ID in(select T_ID from inserted)) IF (@@ERROR <> 0)
Begin
ROLLBACK TRAN
RAISERROR ('同步数据时出错!', 16, 1)
Return
End
COMMIT TRAN 如果是sql2005,
可以用TransactionScope
http://blog.csdn.net/fanweiwei/archive/2007/05/21/1619241.aspx
触发器么就按照你要的逻辑来啊