举手之劳,不胜感激(50)

请哪位顺手帮忙,把下面的ORACLE触发器译成SQLSERVER中的,谢谢.create or replace trigger trigger1before update of fields1 on table1for each rowbegin if :new.fields1=1 then :new.fields:=10; end if;end;

对ORACAL不熟,但可以给你SQL里触发器方式CREATE TRIGGER [触发器名称] ON dbo.数据表名称FOR DELETEASdeclare @CHKD_ID varchar(20) //定义变量名称DECLARE delete_cursor//游标名 CURSOR FOR select CHKD_ID//字段名 from deleted OPEN delete_cursor//游标名FETCH NEXT FROM delete_cursor//游标名 INTO @CHKD_IDif @CHKD_ID is not nullBEGIN WHILE @@FETCH_STATUS = 0 BEGIN //处理内容 FETCH NEXT FROM delete_cursor//游标名 INTO @CHKD_ID ENDENDCLOSE delete_cursor//游标名DEALLOCATE delete_cursor//游标名这是一个删除是触发器,如果是新增数据里是FOR INSERT select CHKD_ID//字段名 from inserted不知对你有没有用