create trigger trIns on kof
instead ofinsert
as
begin
declare @n int
set @n=(select cast(isnull(MAX(id),0) as int) from kof);
with cte as
(
select rn=right('0000000'+rtrim(@n+ROW_NUMBER()over(order by getdate())),8),value
from inserted
)
insert kof
select * from cte
end
如上,这个cte是什么东西啊,好像没看到表里面有定义cte。。。