Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 convert int32 to int64

Author  Topic 

phanicrn
Starting Member

42 Posts

Posted - 2008-02-21 : 10:12:39
hi
i am doing union of two queries and getting result. as we know datatypes should match

for query1 it has int 64

now how do i convert int32 to int 64. i am just putting dummy values in quey2 to match query1

dineshasanka
Yak Posting Veteran

72 Posts

Posted - 2008-02-21 : 11:00:58
CAST one of your data sets so that both will match to gether
Go to Top of Page
   

- Advertisement -