create table t_tiaoma(haoma varchar(10))insert into t_tiaoma values('570462')
insert into t_tiaoma values('331523')
insert into t_tiaoma values('280365')怎么写sql语句生成?
insert into t_tiaoma values('331523')
insert into t_tiaoma values('280365')怎么写sql语句生成?
insert into tb values('570462')
insert into tb values('331523')
insert into tb values('280365')
godeclare @id as varchar(6)select @id = right('000000' + cast(cast(rand(checksum(newid()))*100000 as int) as varchar),6) from sysobjectsinsert into tb select @id where @id not in (select haoma from tb)select * from tbdrop table tb/*
haoma
----------
570462
331523
280365
041371
*/
insert @t select 100000+abs(checksum(newid()))%(999999-100000+1)
insert @t select 100000+abs(checksum(newid()))%(999999-100000+1)
insert @t select 100000+abs(checksum(newid()))%(999999-100000+1)
select * from @t
/*
num
----------
495604
386206
185802(3 個資料列受到影響)
*/