您可能需要考虑构建查询。
DECLARE @Number varchar(10)DECLARE @Where varchar(max)DECLARE @Query varchar(max)SET @Query = 'SELECt * FROM TestTable'SET @Where = ''SET @Number = '3'IF ISNULL(@Number, '') != ''BEGIN SET @Where = @Where + 'and testNumber = ' + @NumberENDIF LEN(@Where) > 0BEGIN SET @Where = SUBSTRINg(@Where, 4, LEN(@Where))ENDif ISNULL(@Where, '') != ''BEGIN SET @Query = @Query + ' WHERe ' + @WhereENDEXEC(@Query)
