Generate Unique ID Values

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

   "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;"
        }
      ]
    }