SQL IF..ELSE..在存储过程的使用规范

王朝mssql·作者佚名  2008-05-31
窄屏简体版  字體: |||超大  

CREATE PROCEDURE [dbo].[sp_stat_info]

(

@city nvarchar(20),

@town nvarchar(20),

@village nvarchar(20)

)

as

declare @num numeric(10)

declare @yd_num numeric(10)

declare @lt_num numeric(10)

declare @gh_num numeric(10)

declare @xlt_num numeric(10)

select @num=count(jmzh) from jfxd.t_gongan_end_2

if @city='aaa'

begin

select @yd_num=count(jmzh) from jfxd.t_gongan_end_2 where SERIAL_NUMBER is not null

select @lt_num=count(jmzh) from jfxd.t_gongan_end_2 where unicom is not null

select @gh_num=count(jmzh) from jfxd.t_gongan_end_2 where tel is not null

select @xlt_num=count(jmzh) from jfxd.t_gongan_end_2 where little_tel is not null

end

else if @town='bbb'

begin

//sql语句

end

else

begin

//sql语句

end

update t_stat_info set……

GO

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航