--首先检查是否已存在该存储过程，如果存在则删除重建

if exists(select name from sysobjects where name='getPersonNameandEmail_bylcy' and type='P')
drop procedure getPersonNameandEmail_bylcy
go

create procedure getPersonNameandEmail_bylcy @goid nvarchar(40),@name nvarchar(300) output,
@email nvarchar(400) output
as
begin

--定义游标
declare nameCur_bylcy cursor scroll dynamic
for
select personname,personemail from tblperson where oid in (select personguid from tblgroupandperson where groupguid
='324FD9AC-C7AE-4FD6-ADB9-4BFF3CF63F65')
open nameCur_bylcy

declare @tname nvarchar(30),@temail nvarchar(40)
set @name=''
set @email=''
fetch next from nameCur_bylcy into @tname,@temail

while (@@fetch_status=0)
begin
set @name=@name+ ','+@tname
set @email=@email+','+@temail

fetch next from nameCur_bylcy into @tname,@temail
end
close nameCur_bylcy
deallocate nameCur_bylcy

end
go

declare @tmpName nvarchar(300),@tmpEmail nvarchar(400)

execute getPersonNameandEmail_bylcy '324FD9AC-C7AE-4FD6-ADB9-4BFF3CF63F65',@tmpName output,@tmpEmail output

print substring(@tmpName,2,len(@tmpName)-1)
print ' '
print substring(@tmpEmail,2,len(@tmpEmail)-1)
go