Skip to content

Instantly share code, notes, and snippets.

@joncloud

joncloud/SqlCache.idempotent.sql

Created March 14, 2021 20:11
Show Gist options
  • Save joncloud/0415994d0b78f97d31b21592389ea108 to your computer and use it in GitHub Desktop.
Save joncloud/0415994d0b78f97d31b21592389ea108 to your computer and use it in GitHub Desktop.
Download ZIP
sql-cache-tool Output
Raw
SqlCache.idempotent.sql
IF NOT EXISTS (
SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'dbo' AND TABLE_NAME = 'SqlCache'
)
BEGIN
CREATE TABLE [dbo].[SqlCache](Id nvarchar(449) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL, Value varbinary(MAX) NOT NULL, ExpiresAtTime datetimeoffset NOT NULL, SlidingExpirationInSeconds bigint NULL,AbsoluteExpiration datetimeoffset NULL, PRIMARY KEY (Id))
CREATE NONCLUSTERED INDEX Index_ExpiresAtTime ON [dbo].[SqlCache](ExpiresAtTime)
END
Raw
SqlCache.sql
CREATE TABLE [dbo].[SqlCache](Id nvarchar(449) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL, Value varbinary(MAX) NOT NULL, ExpiresAtTime datetimeoffset NOT NULL, SlidingExpirationInSeconds bigint NULL,AbsoluteExpiration datetimeoffset NULL, PRIMARY KEY (Id))
CREATE NONCLUSTERED INDEX Index_ExpiresAtTime ON [dbo].[SqlCache](ExpiresAtTime)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment