Home Forums SQL Server 2005 T-SQL (SS2K5) Set Variable based on a SELECT RE: Set Variable based on a SELECT

  • February 10, 2010 at 9:08 am

    #1116923

    You can convert it back to datetime if you need to :

    INSERT INTO tableA (columnA)

    SELECT CONVERT(datetime,@mydate)

    Converting oxygen into carbon dioxide, since 1955.