存储过程经典用法
时间:2011-12-27 23:31来源: 作者:admin 点击: 次
SET QUOTED_IDENTIFIER ON
2 GO
3 SET ANSI_NULLS OFF
4 GO
5 if ( select dbo.sysobjects where id = N 'IsProcedure')
6 drop
7 GO
8
9
10
11createGetOperationLogs
12(
13 @useridList
14 @BeginTime
15 @EndTime
16 @description
17)
18as
19begin
20 declare
21 set * from d_lg_6 '
22
23 if (( @useridList=null)and(@BeginTime=null)and(@EndTime=null)and(@Description=null))
24 begin
25 exec(@s)
26 return
27 end
28 set where '
29
30 if ( @useridList!=null)
31 set userid in ( '+@useridList+') and '
32
33 if (( @BeginTime!=null)and(@EndTime!=null))
34 set logtime between '''+convert(varchar(19),@BeginTime,120)+''' and '''+convert(varchar(19),@endtime,120)+''' and '
35
36 if ( @Description!=null)
37 set Description like ''%'+@Description+'%'''
38 if ( substring(@s,len(@s)-2,3)='and')
39 set
40 exec(@s)
41 --select @s
42 --select substring(@s,len(@s)-2,3)
43end
44GO
45SETQUOTED_IDENTIFIER OFF
47SETANSI_NULLS ON
10
11create
13
15
16
17)
18as
19begin
20
21
22
23
24
25
26
27
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43end
44GO
45SET
47SET