What is correct way to declare varbinary in SQL Server 2008?

3.9k Views Asked by At

What is correct way to declare varbinary in SQL Server 2008? Now I declaring like this

    DECLARE @BinaryValue varbinary(MAX)
1

There are 1 best solutions below

0
On BEST ANSWER

The correct way is like this:

DECLARE @BinaryValue varbinary(MAX)

Consider specifying a length instead of MAX, if you can.