Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jackal Date data type RE: Date data type

  • April 28, 2010 at 8:23 am

    #1158964

    Chad Crawford (4/28/2010)

    This was quite a surprise to me. I would have expected the Date and Datetime to have worked the same way, but I guess that's why I come back here every day.

    Hugo Kornelis (4/28/2010)

    In SQL Server 2008, not terminating statements with a semicolon is deprecated.

    This was even a bigger surprise. I saw that you could do it in 2K8

    You could do it in SQL 2005 and SQL 2000 as well. Probably in 7.0 too, maybe even before that, but my memory sometimes fails me.

    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/