Running a Data Compare and sync for SQL Server tables. When running the Sync script the following error is displayed
'Incorrect syntax near ''.'
On reviewing the delete SQL statement that Toad has produced, I identified the following statement
[DESCRIBED_PREMISES_TXT] IS ''
the contents of the cell is blank ,not NULL
the syntax should be
[DESCRIBED_PREMISES_TXT] = ''
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center