Procedure: [AdventureWorks2016CTP3].[dbo].[AUDIT_prc_ReportingAddFilterValue]

CollapseAll image

Collapse image Procedure properties


 Name   Value 
 Schema   [dbo] 
 Owner   [dbo] 
 Creation date   21.09.2016 
 Type   P 
 Encrypted   
 ID   56387270 
 Implementation type   Transact SQL 
 Is native compiled   

Collapse image Creation options


Name Value
QUOTED_IDENTIFIER ON
ANSI_NULLS ON

Collapse image Parameters


Name  Description Datatype  Max length  Type  ReadOnly
@index   nvarchar 100 Input  
@value   nvarchar 4000 Input  

Collapse image Objects that depend on [dbo].[AUDIT_prc_ReportingAddFilterValue]


Object name Object type Dep level
[dbo].[AUDIT_prc_DeleteArchitecture] Procedure 1
Total 1 object(s)

Collapse image SQL


SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO

create procedure dbo.AUDIT_prc_ReportingAddFilterValue
@index nvarchar(100),
@value nvarchar(4000)
as
begin
if not exists (select [value] from ##Filter where [index]=@index and [value] like Replace(@value collate database_default, '[', '[[]'))
    insert into ##Filter([index], [value]) values(@index, @value)
end
GO

Collapse image See also


List of procedures