Hi!

I currently use conesans checksum component, but I need a md5-checksum
pushed into a bigint (I believe conesans uses crc-32).
Has anyone solved this?

regards,
Gorm Braarvig

Gorm,

Starting with SQL Server 2005 there is a HASHBYTES keyword that allows you
to choose from a set of methods and returns VARBINARY. It can be cast into
BIGINT, but it is not reversable.

The MD5 method returns 16 bytes, but BIGINT is only 8 bytes.

See the output of the following:

SELECT HASHBYTES('MD5','Gorm Braarvig') AS BINMD5,
CAST (HASHBYTES('MD5','Gorm Braarvig') AS BIGINT) AS BIGINTMD5,
CAST (CAST (HASHBYTES('MD5','Gorm Braarvig') AS BIGINT)
AS VARBINARY(8000)) AS BINAGAINMDF

Results:
0x647679B1F3F515655EC3B478951307CF 6828499890013931471 0x5EC3B478951307CF

Does that help?

RLF

"Gorm Braarvig" <gorm_b (AT) hotmail (DOT) com> wrote

Gorm,

Starting with SQL Server 2005 there is a HASHBYTES keyword that allows you
to choose from a set of methods and returns VARBINARY. It can be cast into
BIGINT, but it is not reversable.

The MD5 method returns 16 bytes, but BIGINT is only 8 bytes.

See the output of the following:

SELECT HASHBYTES('MD5','Gorm Braarvig') AS BINMD5,
CAST (HASHBYTES('MD5','Gorm Braarvig') AS BIGINT) AS BIGINTMD5,
CAST (CAST (HASHBYTES('MD5','Gorm Braarvig') AS BIGINT)
AS VARBINARY(8000)) AS BINAGAINMDF

Results:
0x647679B1F3F515655EC3B478951307CF 6828499890013931471 0x5EC3B478951307CF

Does that help?

RLF

"Gorm Braarvig" <gorm_b (AT) hotmail (DOT) com> wrote

Gorm,

Starting with SQL Server 2005 there is a HASHBYTES keyword that allows you
to choose from a set of methods and returns VARBINARY. It can be cast into
BIGINT, but it is not reversable.

The MD5 method returns 16 bytes, but BIGINT is only 8 bytes.

See the output of the following:

SELECT HASHBYTES('MD5','Gorm Braarvig') AS BINMD5,
CAST (HASHBYTES('MD5','Gorm Braarvig') AS BIGINT) AS BIGINTMD5,
CAST (CAST (HASHBYTES('MD5','Gorm Braarvig') AS BIGINT)
AS VARBINARY(8000)) AS BINAGAINMDF

Results:
0x647679B1F3F515655EC3B478951307CF 6828499890013931471 0x5EC3B478951307CF

Does that help?

RLF

"Gorm Braarvig" <gorm_b (AT) hotmail (DOT) com> wrote

Gorm,

Starting with SQL Server 2005 there is a HASHBYTES keyword that allows you
to choose from a set of methods and returns VARBINARY. It can be cast into
BIGINT, but it is not reversable.

The MD5 method returns 16 bytes, but BIGINT is only 8 bytes.

See the output of the following:

SELECT HASHBYTES('MD5','Gorm Braarvig') AS BINMD5,
CAST (HASHBYTES('MD5','Gorm Braarvig') AS BIGINT) AS BIGINTMD5,
CAST (CAST (HASHBYTES('MD5','Gorm Braarvig') AS BIGINT)
AS VARBINARY(8000)) AS BINAGAINMDF

Results:
0x647679B1F3F515655EC3B478951307CF 6828499890013931471 0x5EC3B478951307CF

Does that help?

RLF

"Gorm Braarvig" <gorm_b (AT) hotmail (DOT) com> wrote

Gorm,

Starting with SQL Server 2005 there is a HASHBYTES keyword that allows you
to choose from a set of methods and returns VARBINARY. It can be cast into
BIGINT, but it is not reversable.

The MD5 method returns 16 bytes, but BIGINT is only 8 bytes.

See the output of the following:

SELECT HASHBYTES('MD5','Gorm Braarvig') AS BINMD5,
CAST (HASHBYTES('MD5','Gorm Braarvig') AS BIGINT) AS BIGINTMD5,
CAST (CAST (HASHBYTES('MD5','Gorm Braarvig') AS BIGINT)
AS VARBINARY(8000)) AS BINAGAINMDF

Results:
0x647679B1F3F515655EC3B478951307CF 6828499890013931471 0x5EC3B478951307CF

Does that help?

RLF

"Gorm Braarvig" <gorm_b (AT) hotmail (DOT) com> wrote

Gorm,

Starting with SQL Server 2005 there is a HASHBYTES keyword that allows you
to choose from a set of methods and returns VARBINARY. It can be cast into
BIGINT, but it is not reversable.

The MD5 method returns 16 bytes, but BIGINT is only 8 bytes.

See the output of the following:

SELECT HASHBYTES('MD5','Gorm Braarvig') AS BINMD5,
CAST (HASHBYTES('MD5','Gorm Braarvig') AS BIGINT) AS BIGINTMD5,
CAST (CAST (HASHBYTES('MD5','Gorm Braarvig') AS BIGINT)
AS VARBINARY(8000)) AS BINAGAINMDF

Results:
0x647679B1F3F515655EC3B478951307CF 6828499890013931471 0x5EC3B478951307CF

Does that help?

RLF

"Gorm Braarvig" <gorm_b (AT) hotmail (DOT) com> wrote

Gorm,

Starting with SQL Server 2005 there is a HASHBYTES keyword that allows you
to choose from a set of methods and returns VARBINARY. It can be cast into
BIGINT, but it is not reversable.

The MD5 method returns 16 bytes, but BIGINT is only 8 bytes.

See the output of the following:

SELECT HASHBYTES('MD5','Gorm Braarvig') AS BINMD5,
CAST (HASHBYTES('MD5','Gorm Braarvig') AS BIGINT) AS BIGINTMD5,
CAST (CAST (HASHBYTES('MD5','Gorm Braarvig') AS BIGINT)
AS VARBINARY(8000)) AS BINAGAINMDF

Results:
0x647679B1F3F515655EC3B478951307CF 6828499890013931471 0x5EC3B478951307CF

Does that help?

RLF

"Gorm Braarvig" <gorm_b (AT) hotmail (DOT) com> wrote

Gorm,

Starting with SQL Server 2005 there is a HASHBYTES keyword that allows you
to choose from a set of methods and returns VARBINARY. It can be cast into
BIGINT, but it is not reversable.

The MD5 method returns 16 bytes, but BIGINT is only 8 bytes.

See the output of the following:

SELECT HASHBYTES('MD5','Gorm Braarvig') AS BINMD5,
CAST (HASHBYTES('MD5','Gorm Braarvig') AS BIGINT) AS BIGINTMD5,
CAST (CAST (HASHBYTES('MD5','Gorm Braarvig') AS BIGINT)
AS VARBINARY(8000)) AS BINAGAINMDF

Results:
0x647679B1F3F515655EC3B478951307CF 6828499890013931471 0x5EC3B478951307CF

Does that help?

RLF

"Gorm Braarvig" <gorm_b (AT) hotmail (DOT) com> wrote

Hi Russel!

Can't use it, need to do it in the flow. I was thinking of merging the 16
bytes into 8 by xoring the two Int64 together, would be sufficient for most
(all?) applications.

Thanks,
Gorm

"Russell Fields" <russellfields (AT) nomail (DOT) com> wrote