Skip to content

Bug: Incorrect syntax near the keyword 'WITH' BulkMergeAsync#642

Merged
mikependon merged 1 commit intomikependon:masterfrom
stefandevo:master
Nov 13, 2020
Merged

Bug: Incorrect syntax near the keyword 'WITH' BulkMergeAsync#642
mikependon merged 1 commit intomikependon:masterfrom
stefandevo:master

Conversation

@stefandevo
Copy link
Copy Markdown
Contributor

Fixes #640

@mike_pendon
SQL Server with Alias + Hints Syntax:

  • INSERT, DELETE, UPDATE has an identical syntax (i.e.: SELECT * FROM Table T WITH (NOLOCK)).

  • MERGE has different syntax (MERGE INTO Table WITH (TABLOCK) T).

You cannot just switch that, otherwise you will get a syntax error.
@SQLServer

@mikependon mikependon merged commit da3378d into mikependon:master Nov 13, 2020
@mikependon
Copy link
Copy Markdown
Owner

Thanks @stefandevo for this PR. Will issue a beta for you this weekend, including all the other updates.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Bug: Incorrect syntax near the keyword 'WITH' BulkMergeAsync

2 participants