这样?select top 100 a='a',id=identity(int,1,1) into #t from sysobjects,syscolumnsselect * from #t order by newid()drop table #t
这样可能大家看的更清楚些,我可能没写清楚 table1 table2 把table1和table2的数据写到table3中 id name id code id name code 1 a 1 1 1 a 1 2 3 2 a 3 3 4 3 a 4
insert into table3 select table2.id,table1.name,table2.code from table1 ,table2
insert into table3 (id,name,code) select table2.id,table1.name,table2.code from table1 ,table2
create table t1 (id int, name varchar(10)) insert into t1 select 1,'a'create table t2 ( id int, code int ) insert into t2 select 1,1 union all select 2,3 union all select 3,4 create table t3 ( id int, name varchar(10), code int ) insert into t3 select a.id,b.name,a.code from t1 b,t2 aselect * from t3id name code ----------- ---------- ----------- 1 a 1 2 a 3 3 a 4(3 row(s) affected)
update t
set code=ceiling(rand()*10)
order by newid()drop table #t
table1 table2 把table1和table2的数据写到table3中
id name id code id name code
1 a 1 1 1 a 1
2 3 2 a 3
3 4 3 a 4
select table2.id,table1.name,table2.code from table1 ,table2
select table2.id,table1.name,table2.code from table1 ,table2
(id int, name varchar(10)) insert into t1
select 1,'a'create table t2
(
id int,
code int
)
insert into t2
select 1,1 union all
select 2,3 union all
select 3,4 create table t3
(
id int,
name varchar(10),
code int
)
insert into t3
select a.id,b.name,a.code from t1 b,t2 aselect * from t3id name code
----------- ---------- -----------
1 a 1
2 a 3
3 a 4(3 row(s) affected)