insert a1(id,rk,name,flag) select 5,'dd','ly',flag from a2 where name='bbb'
用以下方式 记住查询只能返回一个值 create table i(ids int,i varchar(100)) insert into i select 1,'a'create table ai(ids int,a varchar(100)) insert into i select 1,(select i from i where i='a')
declare @tt varchar(10) select @tt=flag from a2 where name='bbb' insert into a1(id,rk,name,falg) values(5,'dd','ly',@tt) go 如果你插入的记录比较多,可以考虑用游标。
insert into a1(id,rk,name,flag) select 5,'dd','ly',flag from a2 where name='bbb'
insert into a1(id,rk,name,flag) select '5','dd','ly',flag from a2 where name='bbb'
把,(select flag from a2 where name="bbb")赋值给一个变量@Ninsert into a1(id,rk,name,flag) values(5,'dd','ly',@N)
insert a1 (id,rk,name,flag) select 5,'dd','ly',flag from a2 where name='bbb'
insert a1 (id,rk,name,flag) select 5,'dd','ly',flag from a2 where name='bbb'
select @n=(select flag from a2 where name="bbb")insert into a1(id,rk,name,flag) values(5,'dd','ly',@n)
(select top 1 flag from a2 where name='bbb')(select max(flag) from a2 where name='bbb')
记住查询只能返回一个值
create table i(ids int,i varchar(100))
insert into i select 1,'a'create table ai(ids int,a varchar(100))
insert into i select 1,(select i from i where i='a')
select @tt=flag from a2 where name='bbb'
insert into a1(id,rk,name,falg)
values(5,'dd','ly',@tt)
go
如果你插入的记录比较多,可以考虑用游标。