insert into tb select 1,'aa' union all select 2,'bb'insert tablea(col1,col2,...) values(1,2,3,...) insert tablea(col1,col2,...) values(4,5,6,...) 都可以
可以用trigger --------------------------- create table test ( a int ) go create trigger insert_two_reocrd on test for insert as declare @a int select @a=inserted.a from inserted insert into test values (@a) go insert into test values (1) go select * from test这样同时会插入两条记录
select 字段值列表1
union all select 字段值列表2
create table tb(id int,name varchar(20))--往表中插入两条记录
insert into tb
select 1,'aa'
union all select 2,'bb'
insert tablea(col1,col2,...) values(4,5,6,...)
insert table2(c1,c2,...) values(1,2,....)
select 1,'aa'
union all select 2,'bb'insert tablea(col1,col2,...) values(1,2,3,...)
insert tablea(col1,col2,...) values(4,5,6,...)
都可以
---------------------------
create table test (
a int
)
go
create trigger insert_two_reocrd on test
for insert
as
declare @a int
select @a=inserted.a from inserted
insert into test values (@a)
go
insert into test values (1)
go
select * from test这样同时会插入两条记录