use pubs
go
if exists(select * from sysobjects where name = 'test')
drop table test
go
create table test
(
    pid int default(32),
    rid int default(1),
    uid int,
)
go
insert into test(uid) values(1)
go
--创建存储过程
if exists(select * from sysobjects where name = 'tt')
drop proc tt
go
create proc tt
as
declare @num int
select @num=uid from test
while @num<=514
begin
insert into test(uid) values(@num)
set @num=@num+1
end
go
exec tt
go
select * from test
go
--delete test

这样的问题想回答都难！

- -
补充一个问题
 存储过程
如何输入ABCD
   输出A，B，C，D

case?

请问是什么问题.我测试过了.没有一点问题.运行得好好的.