BUG: The return data type depends on the location of a UNION operation where char and varchar data types are combined in SQL Server 2000

Consider the following scenario. In Microsoft SQL Server 2000, char and varchar data types are combined in a UNION operation. If the UNION operation is included in a view or in a subquery, the return data type of the combined column is char. If the UNION operation is a stand-alone query, the return

Read More - Register for Free Membership