Searching for binary - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Searching for binary

Message

25/01/2014 11:32:21

25/01/2014 01:30:18

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

Versions des environnements

SQL Server:

SQL Server 2008

Application:

Web

Divers

Thread ID:

01592413

Message ID:

01592418

Vues:

>You didn't specify the size in DECLARE statement for @MD5

Good catch, this works.

This is the adjusted code:

DECLARE @MD5 Binary(16)

SET @MD5=0xB3C54EFB6C02017046905007293650B1

SELECT * FROM MyTable WHERE MyTable.MD5=@MD5