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

Question

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

    DECLARE @BinaryValue varbinary(MAX)

http://stackoverflow.com/questions/12426756/using-variable-to-specify-size-when-declaring-a-varbinary — Akash KC, Aug 26 '13 at 05:35

score 2 · Accepted Answer · answered Aug 26 '13 at 05:34

2

The correct way is like this:

DECLARE @BinaryValue varbinary(MAX)

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

answered Aug 26 '13 at 05:34

ta.speot.is

1 Answers1