Counter Table
CREATE TABLE [dbo].[GenericCounter]( [ID] [bigint] IDENTITY(1000,1) NOT NULL, [Allocation Date] [datetime] NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[GenericCounter] ADD CONSTRAINT [DF_GenericCounter_Allocation Date] DEFAULT (getdate()) FOR [Allocation Date] GO
Configuration
"resquel": { "type": "mssql", "db": { "user": "mysqluser", "password": "mysqluserpassword", "server": "myserver\\myinstance", "database": "mydatabase", "requestTimeout":"30000" }, "routes": [ { "method": "get", "endpoint": "/counter/id", "query": "insert into GenericCounter default values;select SCOPE_IDENTITY() as SequentialID;" } ] }