针对你的表:
create proc PrNameString
@nameString varchar(4000) output
as
begin
set @nameString=''
select @nameString=@nameString+[学生姓名]+',' from 学生登记表 where [班级]='801021'
if @@Error=0
return 1
end
--调用方法:
declare @chvNameString varchar(4000)
declare @intReturnValue int
exec @intReturnValue=prNameString @chvNameString output
if @intReturnValue=1
select @intReturnVlue