Home Forums Article Discussions Article Discussions by Author Discuss content posted by Hugo Kornelis Round up or down III RE: Round up or down III

  • August 17, 2010 at 8:21 am

    #1207906

    Toreador (8/17/2010)

    So why not just make it a Bit datatype and call it 'Truncate' instead of 'Function'? Did it original behave differently?

    Good question. And I have no idea.

    I did check in the SQL Server 2000 version of Books Online (the oldest version I was able to find online), and it was the same then.

    Maybe it's for ANSI compliance? (the SQL Server BIT datatype is not ANSI-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/