通过一下的例子可以学习 : 触发器的定义,如何通过 select语句给变量赋值等...
alter trigger zTrigger on test
instead of insert
as
begin
declare @i varchar(10)
declare @m int
declare @str char(50)
select @str = zName from inserted
select @m = max(substring(id,2,len(id)))from test
set @i = isnull(@m,0)+1
insert into test(id,zName) values()
end
insert into test(zName) values('hhh2')
select * from test
delete from test