sp_getsumage.sql

来自「数据库封装原代码 1. 该代码可以免费使用, 该代码的名字暂时定为"哲别" 2」· SQL 代码 · 共 40 行

USE [Sample]
GO
/****** Object:  StoredProcedure [dbo].[sp_GetSumAge]    Script Date: 04/03/2007 16:52:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[sp_GetSumAge] 
	@nFromAge	int=0,
	@nToAge		int=0
AS
	if (@nFromAge is null or @nFromAge = 0) and (@nToAge is null or @nToAge = 0)
	begin
		SELECT Sum([Age]) AS SumAge
		FROM tabUser
	end
	else if (@nFromAge is null or @nFromAge = 0) and not (@nToAge is null or @nToAge = 0)
	begin
		SELECT Sum([Age]) AS SumAge
		FROM tabUser
		WHERE [tabUser].[Age] <= @nToAge
	end
	else if not (@nFromAge is null or @nFromAge = 0) and (@nToAge is null or @nToAge = 0)
	begin
		SELECT Sum([Age]) AS SumAge
		FROM tabUser
		WHERE [tabUser].[Age] >= @nFromAge
	end
	else if not (@nFromAge is null or @nFromAge = 0) and not (@nToAge is null or @nToAge = 0)
	begin
		SELECT Sum([Age]) AS SumAge
		FROM tabUser
		WHERE [tabUser].[Age] >= @nFromAge and [tabUser].[Age] <= @nToAge
	end