• mtillman-921105 (8/3/2010)


    Third, us humans don't think this way typically I don't believe (thus, the good main question here). Since SQL is our tool, we should dictate how it works rather than vice-versa.

    Which, for the record, can be done by explicitly casting the arguments to the desired data type. Which you'll only do if you know how the tool works.

    Thanks for the interesting discussion, mtillman and Oleg! 🙂


    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/