请教各位专家，ORACLE10G中的触发器该如何迁移到SQL SERVER中？ORACLE中的：NEW,:OLD在SQL 中该如何表示？
代码如下：
CREATE OR REPLACE TRIGGER TAU1_BM_JG AFTER Update
ON BM_JG
FOR EACH ROW
declare numrows INTEGER;
begin
if :new.JGBH
ld.JGBH then
select count(*) into numrows from KM_U01 where JGBH =
ld.JGBH;
if (numrows > 0) then
update KM_U01 set JGBH=:new.JGBH where JGBH =
ld.JGBH;
end if;
end if;
end;
