--示例代码 create table a(a int identity,aa varchar(20)) create table b(b int identity,bb varchar(20)) insert b(bb) select 'bb' go create trigger tr_a on a for insert as insert b(bb) select aa from inserted go insert a(aa) select 'aa' select @@identity,scope_identity() go drop table a, b/* ----------------- ----------------------- 2 1(1 row(s) affected)*/
insert into aa (aaa) values ('bbbbb');SELECT @@IDENTITY AS id这个语句是不能动,只能改触发器
create table a(a int identity,aa varchar(20))
create table b(b int identity,bb varchar(20))
insert b(bb) select 'bb'
go
create trigger tr_a on a
for insert
as
insert b(bb)
select aa from inserted
go
insert a(aa) select 'aa'
select @@identity,scope_identity()
go
drop table a, b/*
----------------- -----------------------
2 1(1 row(s) affected)*/