62,073
社区成员
发帖
与我相关
我的任务
分享
declare @mobileOsType int;
declare @mobileUa varchar(50);
declare @id int;
declare @num int;
set @num=100;
while(@num>0)
begin
select @id=convert(int,rand()*100);
select top 1 @mobileUa=title
from awords order by newid();
update ibpencompanyname
set awords=@mobileUa
where id in (select top(@id) id from ibpencompanyname order by newid());
set @num=@num-1;
end
insert into B select Title from A order by newid()
Insert into B(AWORDS)
Select TITLE
from A
Order by newid()