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

2009-12-14 19:04| 发布者: admin| 查看: 29| 评论: 0|原作者: 天仙子

■CREATEPROCEDURE[dbo]......

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

收藏分享邀请

下级分类

GMT+8, 2024-9-30 07:31 , Processed in 0.076994 second(s), 12 queries , Gzip On, MemCache On.

		自动登录	找回密码
密码			注册

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

最新评论

相关分类

下级分类