Posted inSQL
Microsoft
17 years ago
Add language and optimizer support for ISO <distinct predicate>
SQL 1999 and later include the <distinct predicate> IS [NOT] DISTINCT FROM.
Completed
Query Processing and Intelligent DatabaseSuggestionsCompleted
Company Response
Microsoft
Company Response
Up: 289<=-=Aug 9 2007 9:12AM=-=>Benefits:Improved Readability, therefore Maintainablity, therefore reduced manpower $ and time expenditure.<=-=Aug 27 2007 6:13PM=-=>I definitely see the value of this. Thanks for proposing it. We�ll try to squeeze it in to SQL Server 2008 but things are really tight in terms of room for changes like this. It has to compete with many other things, including a bunch that have a larger impact on query performance, or that don�t have an easy workaround. This issue has a workaround, though it is not pretty and programmability would be enhanced a lot with the proposed enhancement. I�ll see what I can do.Best regards,Eric<=-=Oct 17 2007 2:06PM=-=>Things do not look good for this enhancement for Katmai. It probably will not make it into the release. We�ll make a final assessment in a couple of weeks. Before we can consider this, we have to finish other commitments.<=-=Mar 11 2011 6:41AM=-=>What is the Root Duplicate for this please? This links back to 307476 which in turn links back to here but both have been closed as duplicates.<=-=May 25 2011 3:46AM=-=>Surely both items cannot be closed as duplicates. This makes no sense whatsoever. Please can someone at MS sort this out.<=-=Nov 15 2011 11:28AM=-=>This must not be just a syntax shortcut and be difficult to implement. Perhaps 2012?<=-=Apr 23 2012 4:27PM=-=>Hello Steve and others,Due to a problem in our bug databases, there is some issue with several connect items not reflecting the status correctly. For this particular item, it is not possible to see the duplicate or the parent item.But please be assured that the requests for IS DISTINCT predicate is our list of things to do for future & we are tracking it.ThanksUmachandar, SQL Programmability Team<=-=Aug 15 2012 12:23AM=-=>Yes, we could use this keyword.On MERGE statements, we only want existing rows updated, if they actually changed.The current syntax is very long and almost unreadable.<=-=J..
Vote
2 Comments