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
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Convert Hexadecimal code to bigint in sqlserver

Author  Topic 

satish439
Starting Member

6 Posts

Posted - 2010-03-29 : 10:50:41
Hi, How to convert Hexadecimal code 0x000000000000000F into bigint using SQL Server

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2010-03-29 : 10:56:56
Using CAST or Convert.

Harsh Athalye
http://www.letsgeek.net/
Go to Top of Page

satish439
Starting Member

6 Posts

Posted - 2010-03-30 : 00:13:08
Can any one give syntax for that
Go to Top of Page

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2010-03-30 : 01:18:03
select cast(0x000000000000000F as bigint)

Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled

http://senthilnagore.blogspot.com/
Go to Top of Page

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2010-03-30 : 01:22:51
select convert(bigint,0x000000000000000F)

Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled

http://senthilnagore.blogspot.com/
Go to Top of Page
   

- Advertisement -