![]() ![]() There are additional options how to run this. The last %% command reverts the statement delimiter from %% to semicolon. The following example show how to re-define the statement delimiter to %%. To fix this insert the command just before the MERGE command in the SQL Commander to temporarily change the statement separator in DbVisualizer. DbVisualizer use semicolon as the default statement separator and split multiple statements based on the position of semicolons. ![]() ![]() The MERGE command for SQL Server require that the statement ends with a semicolon ( ) and that the semicolon remain with the statement when it is executed by the DB server. Modified on: Fri, 21 Feb, 2020 at 9:31 PM Solution home Database Specific SQL Server SQL Server: Running MERGE statement fail
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |