看看那些错了
udsky 2003-08-22 03:16:21 CREATE PROCEDURE myhomelist
@visiter char(20),
@userid char(20),
@money int output,
@uflag char(16) output,
@exper int output,
@Uhomere char(200) output,
@Uhomeimage int output
AS
select
case uhomeleve
when 0 then return 0
when 1 then
if not exists (select F_name from myFriend where U_id=@userid and f_name=@visiter)
return 0
else
select @money=umoney,@uflag=uflag,@exper=uexper,@UhomeRe=UhomeRe,@Uhomeimage=uhomeimage from userinfo where uname=userid
end
from userinfo where uname=@userid
GO