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 + '%'