spDelete_CacheItem

Parameters

Parameter Parameter Type Mode Description
@Key nvarchar(255) IN
@Exact bit IN

Definition

Copy


            Create Procedure dbo.spDelete_CacheItem
            (
                @Key        nvarchar(255),
                @Exact        bit
            )
            AS

            if @Exact =1
                delete from CacheItems where [key]=@key    
            else
                delete from CacheItems where [key] like @key + '%'