Home Forums Article Discussions Article Discussions by Author Discuss content posted by Gopi Sri T-SQL RE: T-SQL

  • March 22, 2011 at 9:55 am

    #1301958

    Bradley Deem (3/22/2011)

    UMG Developer (3/21/2011)

    Interesting question, thanks, and a good reason you should always specify the data type for hardcoded items in the first set of values or in the first query when using UNION.

    I'm not sure this is true. It looks to me Data Type Precendence determines the data type not the order in the UNION or VALUES clause. Consider the following.

    Bradley,

    Thanks for pointing that out, of course I should have known better. Here is a link to the Table Value Constructor in BOL that mentions the data type precedence: http://msdn.microsoft.com/en-us/library/dd776382.aspx