MS SQL

MS SQL RSS

HELP!!! Converting Hexadecimal to Decimal or vice versa

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Jul 2009

Posts: 4

Reputation: KRichardson1127 is an unknown quantity at this point

Solved Threads: 0

KRichardson1127 KRichardson1127 is offline

Offline

Newbie Poster

HELP!!! Converting Hexadecimal to Decimal or vice versa

Jul 28th, 2009

I'm in the process of converting two columns in two separate tables...

One column in Table A has a hexadecimal number (with a nvarchar data type) i.e. "A5000000020" and converting it to a decimal it should be "11338713661472"...

In Table B the column has a decimal number (with a bigint data type) i.e "1434519076864" and converting it to a hexadecimal the would make the value "9D500000005"

I keep getting stuck!!!

How can I successfully convert these columns?!

Thanks in advance!!!

•

Join Date: Feb 2009

Posts: 3,210

Reputation: sknake has much to be proud of

Solved Threads: 572

sknake

Offline

.NET Enthusiast

Re: HELP!!! Converting Hexadecimal to Decimal or vice versa

Jul 28th, 2009

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
CREATE PROCEDURE Stp_HexToInt
    @HexValue VARCHAR(20)
AS
BEGIN
    DECLARE @Query nvarchar(100)
    DECLARE @Parameters nvarchar(50)
    DECLARE @ReturnValue INT
 
    if (charindex('0x',@HexValue) = 0)
        SET @HexValue = '0x' + @HexValue
 
 
    SET @Query = N'Select @Result = Convert(int,' + @HexValue + ')'
    SET @Parameters = N'@Result int output'
    Exec master.dbo.Sp_executesql @Query, @Parameters, @ReturnValue Output
 
    RETURN @ReturnValue
END
CREATE PROCEDURE Stp_HexToInt
    @HexValue Varchar(20)
AS
BEGIN
    Declare @Query nvarchar(100)
    Declare @Parameters nvarchar(50)
    Declare @ReturnValue Int

    if (charindex('0x',@HexValue) = 0)
        Set @HexValue = '0x' + @HexValue


    Set @Query = N'Select @Result = Convert(int,' + @HexValue + ')'
    Set @Parameters = N'@Result int output'
    Exec master.dbo.Sp_executesql @Query, @Parameters, @ReturnValue Output

    RETURN @ReturnValue
END