create table khyhli(id int , name varchar(10)) insert into khyhli select '2','AAA' union all select '2','AAA'select * from khyhlidrop table khyhli ================ /* id name 2 AAA 2 AAA */
我已經知道答案了 set rowcount 10 insert into 表 select ... from sysobjects set rowcount 0
insert tb(字段2,字段3) select 字段2,字段3 from tb where ID=6
select * from tb
INSERT TB
SELECT ...UNION ALL
SELECT .
select * into 新表 From 原表
insert into khyhli
select '2','AAA' union all
select '2','AAA'select * from khyhlidrop table khyhli
================
/*
id name
2 AAA
2 AAA
*/
set rowcount 10
insert into 表 select ... from sysobjects
set rowcount 0
select 字段2,字段3 from tb where ID=6