Sql if , È¡²»µ½Êý¾Ý - MS-SQL Server / »ù´¡Àà

Õâ¸öSqlÓдíÎóô? Ϊʲôȡ²»µ½Êý¾ÝÄØ¡£

@strtime varchar(30),
@end varchar(30),
@cname int,
@gname varchar(50)

AS

if @gname='ËùÓÐÒµÎñ'
begin
  select count(*) as s_count,s_gname=@gname from sp_operation where s_client=@cname and s_succdate>@strtime and s_succdate<@end
end
else
declare @gnamedis nvarchar(100)
select @gnamedis=gatename from sp_gallerylist where sp_gallerylist.id=convert(int,@gname)
begin
select count(*) as s_count,s_gname=@gnamedis from sp_operation where s_client=@cname and s_gallery=convert(int,@gname) and s_succdate>@strtime and s_succdate<@end
end

---

else ¿ÉÒÔÈ¡µ½¡£µ«ÊÇifºóÃæÓï¾ä¾ÍÈ¡²»µ½

---

ÒýÓÃ

else ¿ÉÒÔÈ¡µ½¡£µ«ÊÇifºóÃæÓï¾ä¾ÍÈ¡²»µ½

ÄÇÊÇûÓзûºÏÌõ¼þµÄ¼Ç¼°É?

---

Óеİ¡¡£ ÎÒÔÚsqlÀïÖ´ÐпÉÒÔÈ¡µ½Êý¾ÝµÄ

---

@gname='ËùÓÐÒµÎñ'
begin
  select count(*) as s_count,@gname =s_gnamefrom sp_operation where s_client=@cname and s_succdate>@strtime and s_succdate<@end
end
else
begin
declare @gnamedis nvarchar(100)
select @gnamedis=gatename from sp_gallerylist where sp_gallerylist.id=convert(int,@gname)
select count(*) as s_count,@gnamedis =s_gnamefrom sp_operation where s_client=@cname and s_gallery=convert(int,@gname) and s_succdate>@strtime and s_succdate<@end
end

---

£¿±êºìʲôÒâ˼£¿

---

print @gnam