不知道楼主要的是不是这种效果: --创建测试条件 create table cjzb(xh int,cj int,kssj int ,cc varchar(20) ,kcid int ) insert cjzb select 1,85,2005,'zk',213 union all select 2,72,2004,'bk',715 union all select 3,66,2004,'zk',213 union all select 3,55,2003,'zk',202 union all select 4,96,2004,'zk',214 union all select 4,95,2003,'zk',202 union all select 5,42,2005,'bk',712 union all select 5,64,2005,'bk',733 union all select 6,74,2005,'bk',213 create table gdb(id int identity(30000,1),xh int,cc varchar(20),kcid int,sfhg varchar(20),kscs varchar(20)) --测试 insert gdb select xh,cc,233,null,null from cjzb where KCID=213 and KSSJ=2005 select * from gdb --删除测试条件 drop table cjzb,gdb ---结果(所影响的行数为 2 行)id xh cc kcid sfhg kscs ----------- ----------- -------------------- ----------- -------------------- -------------------- 30000 1 zk 233 NULL NULL 30001 6 bk 233 NULL NULL(所影响的行数为 2 行)
create table #t(id int identity(30000,1),xh int,cc varchar(20),kcid int,sfhg varchar(20),kscs varchar(20)) insert #t select xh,cc,233,null,null from cjzb where KCID=213 and KSSJ=2005 insert gdb select * from #t drop table #t select * from gdb
--创建测试条件
create table cjzb(xh int,cj int,kssj int ,cc varchar(20) ,kcid int )
insert cjzb select 1,85,2005,'zk',213
union all select 2,72,2004,'bk',715
union all select 3,66,2004,'zk',213
union all select 3,55,2003,'zk',202
union all select 4,96,2004,'zk',214
union all select 4,95,2003,'zk',202
union all select 5,42,2005,'bk',712
union all select 5,64,2005,'bk',733
union all select 6,74,2005,'bk',213
create table gdb(id int identity(30000,1),xh int,cc varchar(20),kcid int,sfhg varchar(20),kscs varchar(20))
--测试
insert gdb select xh,cc,233,null,null from cjzb where KCID=213 and KSSJ=2005
select * from gdb
--删除测试条件
drop table cjzb,gdb
---结果(所影响的行数为 2 行)id xh cc kcid sfhg kscs
----------- ----------- -------------------- ----------- -------------------- --------------------
30000 1 zk 233 NULL NULL
30001 6 bk 233 NULL NULL(所影响的行数为 2 行)
insert #t select xh,cc,233,null,null from cjzb where KCID=213 and KSSJ=2005
insert gdb select * from #t
drop table #t
select * from gdb