Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

SQL Server: NEXTVAL vs NEXT VALUE FOR #13

Open
danskarda opened this issue Mar 10, 2022 · 0 comments
Open

SQL Server: NEXTVAL vs NEXT VALUE FOR #13

danskarda opened this issue Mar 10, 2022 · 0 comments

Comments

@danskarda
Copy link
Collaborator

My client uses (Azure) SQL Server so I want to add support in fulcro-rad-sql.

One of the issues I encountered was during insertion of new rows. It fails due to SQL syntax differences. It seems that ANSI standard is NEXT VALUE FOR sequence while PostgreSQL syntax is NEXTVAL(seq). Surprisingly MS SQL Server follows ANSI here.

Patch and more issues will follow.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@danskarda