SQL考试一

declare @i int
set @i=1
while(@i<10)
begin
set @i=@i+1
insert into inf1 select * from inf
end








declare ur1 cursor for select noID from inf1
open ur1
declare @nb varchar(20), @j int 
set @j=41001
--fetch from ur1 into @nb  
while @j<=41100
begin 
fetch  from ur1 into @nb
update  inf1 set noID =@j where current of ur1 


set @j=@j+1
end
close ur1
deallocate ur1
select * from inf1










--------------------------------------------------------------第三题
create table guanjian(id1 int,key1 varchar(20))
select* from guanjian
--drop table guanjian
create unique  index index_n1 on guanjian(key1)
declare @k int,@ke int


set @k=990631
while @k<=1000000
begin
set @ke=rand()*100
insert into guanjian values(@k,@ke)
set @k=@k+1
end


--drop index index_n1 on guanjian
declare @dt datetime 
set @dt= getdate()
select * from guanjian where key1='0'
select '索引后',datediff(ms,@dt,getdate())