SQSERVER 2008 EXP中的动态WHERE子句.

问题描述

我正在尝试在我的存储过程中生成动态的where子句.

=== @population nvarchar(max)

declare    @chvSelect varchar(max),
             @chvFrom varchar(max),
             @chvWhere varchar(max),
             @chvOrderby varchar(max),
             @chvSQL varchar(max)
BEGIN


--if @Population is not null

set @chvSelect=''SELECT Localities.Name,FormFields.FieldName, FormInstanceData.Value''
set @chvFrom='' FROM   FormInstances INNER JOIN
                      FormInstanceData ON FormInstances.Id = FormInstanceData.FormInstanceId INNER JOIN
                      Communities INNER JOIN
                      Localities ON Communities.Id = Localities.Id INNER JOIN
                      WCData ON Localities.Id = WCData.LocalityId ON FormInstances.Id = WCData.FormInstanceId INNER JOIN
                      FormFields ON FormInstanceData.FieldId = FormFields.Id ''
set @chvWhere='' WHERE FormFields.FieldName ='' + @Population
--if @Population is not null

--set @chvWhere=@chvWhere + ''FormFields.FieldName ='' + CONVERT(varchar,@Population )
set @chvSQL = @chvSelect+ @chvFrom + @chvWhere
select @chvSQL Query
  --if @debug = 0
        exec (@chvSQL)
  --   else
   --    select @chvSQL

END

当我执行此操作时，我得到无效的列名(``我提供给@population的任何值''实际上是formfields .fieldname是该列，我提供的值应该是该列包含的值.) h2_lin>解决方案