代码 1 set ANSI_NULLS ON 2 set QUOTED_IDENTIFIER ON 3 go 4 5 6 --============================================ 7 -- Author:Jianwen Sha 8 -- Created Date:2010年11月8日 9 -- Description: ****** 10 --============================================ 11 ALTER PROC [dbo].[ ****** ] 12 @str varchar( 500 ) -- 搜索条件 13 AS 14 BEGIN 15 DECLARE @strwhere varchar( 2000 ) 16 SET @strwhere = ' SELECT ****** FROM ****** WHERE ****** BETWEEN ''' 17 + convert(varchar( 20 ),@st, 120 ) 18 + ''' and ''' 19 + convert(varchar( 20 ),@et, 120 ) + '''' + @str 20 21 SET @strwhere = @strwhere + ' AND ******= ' + ltrim( ****** ) 22 23 EXEC (@strwhere) 24 END 25
思路:拼接查询字符串
转载于:https://www.cnblogs.com/angleSJW/archive/2010/11/08/1871901.html
