sqlserver触发器，多次if判断改对应的值(有主键或组合主键时需要关联)

USE [DSB]
GO
/****** Object: Trigger [dbo].[TRIG_DCSIBB] Script Date: 07/16/2019 15:54:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- 修改触发器 [TRIG_DCSIBB]
ALTER trigger [dbo].[TRIG_DCSIBB] on [dbo].[DCSIBB] for insert, update as
-- update dbo.DCSIBB set IBB904=convert( varchar , getdate() , 121 ) from dbo.DCSIBB O join INSERTED I on (O.IBB001=I.IBB001) and (O.IBB002=I.IBB002)
-- 执行
begin
-- 声明变量 @IBB006
declare @IBB006 int;
-- 为变量赋值 = insert时的 IBB006
set @IBB006=(select IBB006 from inserted)
-- 如果 变量小于1000 则执行 update
if @IBB006<1000
-- 注意：！！！ from DCSIBB O join INSERTED I on (O.IBB001=I.IBB001) and (O.IBB002=I.IBB002) 此处IBB001，IBB002为组合主键，需要关联进来进行update
update DCSIBB set IBB960 = '低于1000' from DCSIBB O join INSERTED I on (O.IBB001=I.IBB001) and (O.IBB002=I.IBB002) ;
else
if @IBB006=1000
update DCSIBB set IBB960 = '等于1000' from DCSIBB O join INSERTED I on (O.IBB001=I.IBB001) and (O.IBB002=I.IBB002);
if @IBB006>1000
update DCSIBB set IBB960 = '大于1000' from DCSIBB O join INSERTED I on (O.IBB001=I.IBB001) and (O.IBB002=I.IBB002);
end