触发器转换?

CREATE OR REPLACE TRIGGER "DYT"."UPT_BSS97_TRIG" BEFORE
UPDATETIME OF "ACC_NBR","LRN", "TYPE","PAUSE_STS", "PROD_ID", "SERV_STS", "SSB_TYPE","NAN_TYPE","ONLY_ID","GROUP_ID","NT_TYPE","LANG_ID","OFF_BEGIN","OFF_END","ASS_ID","UPDATETIMEIND" ON "MC_BSS97" FOR EACH ROW 
begin
IF :new.ssb_type<>:old.ssb_type and  :new.ssb_type>0 then
:new.canceltime := sysDATETIME;
END IF;
IF  (:new.ssb_type<>:old.ssb_type) or
(:new.nan_type<>:old.nan_type) or
(:new.serv_sts<>:old.serv_sts) or
(:new.pause_sts<>:old.pause_sts) or
(:new.prod_id<>:old.prod_id) or
(:new.lrn<>:old.lrn )  or
(:new.only_id<>:old.only_id) or
(:new.group_id<>:old.group_id )  or
(:new.nt_type<>:old.nt_type) or
(:new.lang_id<>:old.lang_id) or
(:new.off_begin<>:old.off_begin )  or
(:new.off_end<>:old.off_end )  or
(:new.ass_id<>:old.ass_id )  or
(:new.type<>:old.type) then
:new.modtime := sysDATETIME;   
select upDATETIME97_seq.nextval into :new.upDATETIMEInd from dual;
END IF;
IF (:new.upDATETIMEInd<:old.upDATETIMEInd) then   
select upDATETIME97_seq.nextval into :new.upDATETIMEInd from dual;
END IF;
END;
   大家好,麻烦给我看下这个用oracle写的触发器怎样转换成MSSQL的?  谢谢!!!