Procedure:
[AdventureWorks2016CTP3].[dbo].[AUDIT_prc_ReportingAddFilterValue]
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 |
Creation options
| Name | Value |
| QUOTED_IDENTIFIER | ON |
| ANSI_NULLS | ON |
Parameters
| Name | Description | Datatype | Max length | Type | ReadOnly |
| @index | nvarchar | 100 | Input | ||
| @value | nvarchar | 4000 | Input |
Objects that depend on [dbo].[AUDIT_prc_ReportingAddFilterValue]
| Object name | Object type | Dep level |
| [dbo].[AUDIT_prc_DeleteArchitecture] | Procedure | 1 |
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 |
See also