I am using Beyond Compare 4 to compare SQL files generate with and without the "IF NOT EXISTS" clause.
On one side, you will have 2 single quotes around values (since the whole block is an exec) and the other side will just have 1 single quote.
and cvTaxStatus = 'NONTAX'
vs
and cvTaxStatus = ' 'NONTAX' ' (those are 2-single quotes and not a double quote)
I have made a Grammar rule with a regular expression ''\w+'' (again 2 single quotes not the double quote character).
The right side of the file now shows "black", but the whole line is not showing up an an un-important difference (although I have made this new rule unimportant).
Can someone make a suggestion on how I might make this work?
On one side, you will have 2 single quotes around values (since the whole block is an exec) and the other side will just have 1 single quote.
and cvTaxStatus = 'NONTAX'
vs
and cvTaxStatus = ' 'NONTAX' ' (those are 2-single quotes and not a double quote)
I have made a Grammar rule with a regular expression ''\w+'' (again 2 single quotes not the double quote character).
The right side of the file now shows "black", but the whole line is not showing up an an un-important difference (although I have made this new rule unimportant).
Can someone make a suggestion on how I might make this work?
Comment