34,576
社区成员
发帖
与我相关
我的任务
分享看看那些错了
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
@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
...全文
请发表友善的回复…
发表回复
happydreamer 2003-08-22
- 打赏
- 举报
case when 不能这样嵌套使用
caiyunxia 2003-08-22
- 打赏
- 举报
SELECT中不能加IF ELSE
愉快的登山者 2003-08-22
- 打赏
- 举报
case when 不能这样使用，没有这么强的功能。
