Versions Compared

Old Version 1

changes.mady.by.user Brian Banet

Saved on

compared with

New Version 2

changes.mady.by.user Brian Banet

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Code Block
languagesql
titleCounter 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]

GOGO


Code Block
languagejs
titleConfiguration
   "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;"
        }
      ]
    }