Procedure:
[AdventureWorks2016CTP3].[dbo].[AUDIT_prc_ReportingAddFilterValue]
Name | Value |
Schema | [dbo] |
Owner | [dbo] |
Creation date | 21.09.2016 |
Type | P |
Encrypted | |
ID | 56387270 |
Implementation type | Transact SQL |
Is native compiled |
Name | Value |
QUOTED_IDENTIFIER | ON |
ANSI_NULLS | ON |
Name | Description | Datatype | Max length | Type | ReadOnly |
@index | nvarchar | 100 | Input | ||
@value | nvarchar | 4000 | Input |
Object name | Object type | Dep level |
[dbo].[AUDIT_prc_DeleteArchitecture] | Procedure | 1 |
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 |