一个触发器语法的问题。
create trigger tgr_inst
on yw_send_document
after insert
as
declare A1 varchar(10)
begin
select name into A1 form yw_name where type='0';
update Table_name set type=type+1;
update Table_name set type=0 where type=(select max(type) from Table_name);
:new.c_typer:=A1;
end
这里哪里有问题,为何运行时候有错误,谢谢!
错误为:缺少 BEFORE, AFTER 或 INSTEAD OF 关键字