CREATE TRIGGER wktx ON [dbo].[resultback01]
FOR UPDATE
AS
if update(TX1) or Update(TX2) update R set remains=sunothr-tx1-tx2 from
resultback01 R,inserted I
where R.tx1 <> I.tx1 Or R.tx2 <> I.tx2试一下,看行不行
FOR UPDATE
AS
if update(TX1) or Update(TX2) update R set remains=sunothr-tx1-tx2 from
resultback01 R,inserted I
where R.tx1 <> I.tx1 Or R.tx2 <> I.tx2试一下,看行不行
update aa
set discount=discount
where
resultback01 R,inserted I
where R.tx1 <> I.tx1 Or R.tx2 <> I.tx2
这一语句的含义.