calculate Hash value

• vipin_jha123

  Hall of Fame

  Points: 3085

  More actions

  May 15, 2015 at 1:17 am

  #318226

  Hi ,

  I want to calculate the Hash value of below columns.

  I have table having below columns

  [Equipment_Id] + [EquipmentCompCode] + [EquipmentUnitNo] + [EquipmentSerialNo] + [EquipmentPlateNo] + [EquipmentExpireDate]+ [EquipmentState] + [EquipmentAxles] + [EquipmentDesc] + [EquipmentType] + [EquipmentMDT] + [EquipmentOwner] + [EquipmentMakeYear]

  + [EquipmentLocation] + [EquipmentWeight] + [EquipmentSize] + [EquipmentRadioSerial] + [EquipmentEngineSerial] + [EquipmentTransSerial]

  + [EquipmentCode] + [CreateDate] + [ModifiedDate]

  column data type of both int as well as varchar.

  please suggest me the syntax of same.

• Eirikur Eiriksson

  SSC Guru

  Points: 182915

  More actions

  May 15, 2015 at 1:46 am

  #1798100

  vipin_jha123 (5/15/2015)

  ---

  Hi ,

  I want to calculate the Hash value of below columns.

  I have table having below columns

  [Equipment_Id] + [EquipmentCompCode] + [EquipmentUnitNo] + [EquipmentSerialNo] + [EquipmentPlateNo] + [EquipmentExpireDate]+ [EquipmentState] + [EquipmentAxles] + [EquipmentDesc] + [EquipmentType] + [EquipmentMDT] + [EquipmentOwner] + [EquipmentMakeYear]

  + [EquipmentLocation] + [EquipmentWeight] + [EquipmentSize] + [EquipmentRadioSerial] + [EquipmentEngineSerial] + [EquipmentTransSerial]

  + [EquipmentCode] + [CreateDate] + [ModifiedDate]

  column data type of both int as well as varchar.

  please suggest me the syntax of same.

  Quick questions:

  1) Version of SQL Server / SSIS?

  2) What type of Hash (CHECKSUM, MD5, SHAx etc.)

  3) What is the collision tolerance? (are duplicate hashes ok?)

  😎

  On SQL Server 2012 and later use the CONCAT function otherwise cast non-character values to characters in the concatination.

• SQL.AP

  Hall of Fame

  Points: 3244

  More actions

  May 15, 2015 at 2:08 am

  #1798103

  You can use HASHBYTES.

  https://msdn.microsoft.com/en-IN/library/ms174415.aspx

  ____________________________________________________________

  AP

• Eirikur Eiriksson

  SSC Guru

  Points: 182915

  More actions

  May 16, 2015 at 4:40 pm

  #1798469

  vipin_jha123 (5/15/2015)

  ---

  Hi ,

  I want to calculate the Hash value of below columns.

  I have table having below columns

  [Equipment_Id] + [EquipmentCompCode] + [EquipmentUnitNo] + [EquipmentSerialNo] + [EquipmentPlateNo] + [EquipmentExpireDate]+ [EquipmentState] + [EquipmentAxles] + [EquipmentDesc] + [EquipmentType] + [EquipmentMDT] + [EquipmentOwner] + [EquipmentMakeYear]

  + [EquipmentLocation] + [EquipmentWeight] + [EquipmentSize] + [EquipmentRadioSerial] + [EquipmentEngineSerial] + [EquipmentTransSerial]

  + [EquipmentCode] + [CreateDate] + [ModifiedDate]

  column data type of both int as well as varchar.

  please suggest me the syntax of same.

  Care to elaborate any further as previously requested?

  😎