select top n * into 新表名称 from Table1 where .... order by newid()
同意楼上用order by newid()
select top n 列1,列2... ,identity(int,1,1) as 新主键 into 新表名称 from Table1 where .... order by newid()
那就指定具体列: select top n 列1,列2 .... into 新表名称 from Table1 where .... order by newid()
我的原表是f_id(主键),f_title,f_key,新表是f_id(主键),f_name,f_title,这两个主键是不一样的,新表的主键我可以用标识列,在数据库中自增实现,那用select top n 列1,列2 .... into 新表名称 from Table1 where .... order by newid()这个语句就可以了吗? tobillpu(加勒比小飞猪) identity(int,1,1) as 新主键 这个是什么意思?能解释一下吗?谢谢了
Select top n f_id=Identity(Int,1,1), 列1,列2 into 新表名称 from Table1 where .... order by newid()
identity(int,1,1) as 新主键 就是增加一列自增标识列,分开指定列肯定可以select top n f_title into 新表名称 from Table1 where .... order by newid()
暈,你已經建了表??那就不能這麼寫了。你直接將新建表的f_id設為自增列。然後 Insert 新表名称(Col1,Col2) Select Col1,Col2 From Table1 where .... order by newid()
或者,你是這個意思??f_name是另外的,不是從數據庫中得到的。Insert c_paper (f_title,f_name) Select f_title,'aaa' From c_select
f_name是另外的,f_title是对应的,但我要随机啊~~n条数据
加上NewID()即可啊。Insert c_paper (f_title,f_name) Select f_title,'aaa' From c_select Where ... Order By NewID()
我在程序中是这样写的 insert into c_papselect(f_title, f_a, f_b, f_c, f_d, f_key) select top '"+selectCount+"' f_title, f_a, f_b, f_c, f_d, f_key from c_select order by newid() 提示出错,如果把'"+selectCount+"'设为固定值就可以执行,这个selectCount是没问题的,因为当selectCount为3的时候,程序提示第一行'3'出错,就是'"+selectCount+"'出错,想不太懂
select top n 列1,列2 .... into 新表名称 from Table1 where .... order by newid()
tobillpu(加勒比小飞猪)
identity(int,1,1) as 新主键 这个是什么意思?能解释一下吗?谢谢了
f_id=Identity(Int,1,1),
列1,列2
into 新表名称
from Table1
where ....
order by newid()
就是增加一列自增标识列,分开指定列肯定可以select top n f_title into 新表名称 from Table1 where .... order by newid()
Insert 新表名称(Col1,Col2) Select Col1,Col2 From Table1 where .... order by newid()
Order By NewID()
insert into c_papselect(f_title, f_a, f_b, f_c, f_d, f_key) select top '"+selectCount+"' f_title, f_a, f_b, f_c, f_d, f_key from c_select order by newid()
提示出错,如果把'"+selectCount+"'设为固定值就可以执行,这个selectCount是没问题的,因为当selectCount为3的时候,程序提示第一行'3'出错,就是'"+selectCount+"'出错,想不太懂