[SQL-码农]字符组合式的T-SQL

这是公司的一个办法，可以判断参数Null值，无视这个Where控制

但现在还有更好的:http://blog.csdn.net/cracklibby/article/details/7562587

exec PROCEDURE @year,@month,@area
GO
CREATE procedure ...
@year int,
@month int,
@area varchar(10)
AS
Begin
declare @SQLbase varchar(2000)
declare @SQLLink varchar(2000)
declare @SQLWhere varchar(2000)
set @SQLbase=' select [...],[...],[...],[...],[...]
			from [Tab..]'
set @SQLLink=' '
set @SQLWhere='where 1=1  '


	if(@year is not null and @year <> ''  and @year <> ' ' )
	begin
		set @SQLWhere=@SQLWhere+'  and  year([date...]) = '''+@year+'''  '
	end

	if(@month is not null and @month <> ''  and @month <> ' ' )
	begin
		set @SQLWhere=@SQLWhere+'  and  month([date...]) = '''+@month+'''  '
	end

	if(@area is not null and @area <> ''  and @area <> ' ' )
	begin
		set @SQLWhere=@SQLWhere+'  in  '''+@area+'''  '
	end

--select @SQLbase
--select @SQLLink
--select @SQLWhere
exec (@SQLbase+@SQLLink+@SQLWhere)

END