sql考试二

--第一步
create table guanli(st_name varchar(20),st_no varchar(20),st_age varchar(20))
declare @i int,@j varchar(20),@k varchar(20)
set @i =0
while @i<100
begin
insert into guanli values(@j,@i,@k)
set @i=@i+1
end
select * from guanli
--drop table guanli
------------------------------------------------------------------------------
--第二步
declare @nm varchar(20),@i int
declare ur cursor for select st_no from guanli
open ur
fetch next from ur into @nm


set @i=0
while @i<10
begin
update guanli set st_no='A0'+st_no where current of ur 
--第三步改为 while @i<10 ,,update guanli set st_no='A0'+cast(@i as char)where current of ur 再执行一遍
fetch next from ur into @nm


set @i=@i+1
end
close ur
deallocate ur


------------------------------------------------------------
--第四步
declare ur cursor for select st_no from guanli   
open ur
declare @nb varchar(100),@sq varchar(200)
fetch from ur into @nb   --循环前先fetch一下
while @@FETCH_STATUS=0 --游标读取下一条数据是否成功。
begin 
set @sq='create table '+@nb+'(C_language varchar(10),E_nglish varchar(10),D_atabase varchar(10))'
exec (@sq)
fetch  from ur into @nb
end
close ur
deallocate ur
select * from A00
---------------------------------------------------------第二题