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)
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)