Convert Varbinary to Int and BigInt Gives Different Results

• hot chocolate

  SSC-Addicted

  Points: 419

  More actions

  August 24, 2012 at 12:00 pm

  #260546

  If I run The query below it gives different output

  DECLARE @VB VARBINARY(8000) = CAST('0xD7DF6FC50A6807D31E27505A46DA7EA0' AS VARBINARY(8000))

  SELECT CONVERT(BIGINT, @VB)

  SELECT CONVERT(INT, @VB)

  --3762269585605476656

  --927285552

  Why is this so? The only difference here is bigint can hold more values than int but conversion gives totally different values

  Any explanation appreciated.

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  August 24, 2012 at 12:12 pm

  #1529899

  Simple, BIGINT is 8 bytes while INT is 4 bytes. Run the following code:

  select

  cast(0xD7DF6FC50A6807D31E27505A46DA7EA0 as bigint),

  cast(0xD7DF6FC50A6807D31E27505A46DA7EA0 as int),

  cast(0x1E27505A46DA7EA0 as int)

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  August 24, 2012 at 12:42 pm

  #1529914

  Actually, I think the following provides a better picture:

  select

  cast(0xD7DF6FC50A6807D31E27505A46DA7EA0 as bigint),

  cast(0xD7DF6FC50A6807D31E27505A46DA7EA0 as int),

  cast(0x1E27505A46DA7EA0 as bigint),

  cast(0x1E27505A46DA7EA0 as int),

  cast(0x46DA7EA0 as bigint),

  cast(0x46DA7EA0 as int)

• hot chocolate

  SSC-Addicted

  Points: 419

  More actions

  August 24, 2012 at 1:29 pm

  #1529930

  Thanks Lynn..

  This helps 🙂