spAddUpdate_CacheItem

Parameters

Parameter	Parameter Type	Mode
@Key	nvarchar(255)	IN
@DateAdded	datetime	IN
@Update	bit	IN

Definition

Copy


            CREATE Procedure [dbo].[spAddUpdate_CacheItem] 
            (
                @Key        nvarchar(255),
                @DateAdded    DateTime,
                @Update        bit = 0
            )
            AS

            if NOT exists (select [key] from cacheitems where [key]=@Key)
                insert into CacheItems ([Key], [DateAdded]) values (@Key, @DateAdded)
            else if @Update = 1
                update CacheItems set [DateAdded]=@DateAdded where [key]=@key