How do I Use a MSSQL Sequence for Row ID?

Am watching an incredible video - the “mon de chefs” trainer “NodeJS for Wappler” from @ben .
I’m on video 7.
Great value in this series - doing very well - I knew I was going to get stuck on my 1st INSERT though!
The image below is from the API trying to post a new user registration.

My SQL Server legacy app uses Sequences (instead of Identity column) for primary key. (MySql doesn’t have this, MariaDB does). So for my 1st column, ID, you can see the code I’d use in T-SQL, but its using that as a literal for the numeric ID field.

How to I substitute “NEXT VALUE FOR xxx” into the INSERT statement?

Community Page
Last updated: