• UMG Developer (9/27/2010)


    (However it appears that this is one SQL feature that is commonly implemented differently, if at all.)

    That's probably because all products had already implemented their own syntax for this when the standardisation committee finally decided to forget relational purity and add this commonly needed feature to the standard.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/