代码
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
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
思路:拼接查询字符串