insert into a(a,b,c) select top 100 b,c,d from b order by newid() --隨機從b表選100條記錄插入
1.select 列名 into 新表 from 旧表 (直接建表)2.insert into 新表(列1,列2) select (列1,列2) from 旧表
在程序中生成以下语句: BEGIN INSERT INTO a (a, b) VALUES (1, b) INSERT INTO a (a, b) VALUES (2, b) INSERT INTO a (a, b) VALUES (3, b) INSERT INTO a (a, b) VALUES (4, b) INSERT INTO a (a, b) VALUES (5, b) INSERT INTO a (a, b) VALUES (6, b) INSERT INTO a (a, b) VALUES (7, b) ............... END执行
insert into tablename(a,b) select a,b from othertable 前面和后面的結構要一樣才行。
select top 100 b,c,d from b order by newid()
--隨機從b表選100條記錄插入
BEGIN
INSERT INTO a (a, b) VALUES (1, b)
INSERT INTO a (a, b) VALUES (2, b)
INSERT INTO a (a, b) VALUES (3, b)
INSERT INTO a (a, b) VALUES (4, b)
INSERT INTO a (a, b) VALUES (5, b)
INSERT INTO a (a, b) VALUES (6, b)
INSERT INTO a (a, b) VALUES (7, b)
...............
END执行
select a,b from othertable
前面和后面的結構要一樣才行。