We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
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
Add optional support for the EXCEPT operator in the WHEN MATCHED clause, as described here: http://www.made2mentor.com/2013/05/writing-t-sql-merge-statements-the-right-way/
For Example: WHEN MATCHED AND EXISTS (SELECT Source.Column1, Source.Column2 EXCEPT SELECT Target.Column1, Target.Column2)
This will properly handle NULL values in both the source and target, and will be a little more clear and concise for the developer.
EXCEPT is supported in all currently supported versions of SQL Server, and in Azure SQL Database. https://docs.microsoft.com/en-us/sql/t-sql/language-elements/set-operators-except-and-intersect-transact-sql?view=sql-server-ver15
The text was updated successfully, but these errors were encountered:
Interesting idea!
Sorry, something went wrong.
@NowinskiK I'm feeling the urge to do something again. Mind if I work on this one?
Added ExceptOperator to EComparisonMethod enum. Azure-Player#14
6cdca5b
No branches or pull requests
Add optional support for the EXCEPT operator in the WHEN MATCHED clause, as described here:
http://www.made2mentor.com/2013/05/writing-t-sql-merge-statements-the-right-way/
For Example:
WHEN MATCHED AND EXISTS
(SELECT Source.Column1, Source.Column2
EXCEPT
SELECT Target.Column1, Target.Column2)
This will properly handle NULL values in both the source and target, and will be a little more clear and concise for the developer.
EXCEPT is supported in all currently supported versions of SQL Server, and in Azure SQL Database.
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/set-operators-except-and-intersect-transact-sql?view=sql-server-ver15
The text was updated successfully, but these errors were encountered: