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//主要是with里面的搞不懂。以及with
(
select rn=right('0000000'+rtrim(@n+ROW_NUMBER()over(order by getdate())),8),value
from inserted
)
insert kof
select * from cte
end