开发者

Convert hexadecimal value into bigint

I am getting some trouble converting a string (representing a hexadecimal number) into a bigint. I would also like this to happen inside a function and as effiecient as possible. Is there anyway of exploiting the built-in functions? Here is an example of what I want to do:

select convert (bigint,开发者_如何学运维 '0000010d1858798c')


The SQL Server 2008 release updated the CONVERT() function to be able to convert hexadecimal values:

select convert(bigint, convert (varbinary(8), '0x0000010d1858798c', 1))

Result:

1155754654092 (decimal) ( ==  0x0000010d1858798c )
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜