CODEWITHSUNDEEP
sql-server-2008varbinary
Ankush Madankar
Ankush Madankar

Reputation: 3834

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

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

    DECLARE @BinaryValue varbinary(MAX)

Upvotes: 2

Views: 4176

Answers (1)

ta.speot.is
ta.speot.is

Reputation: 27214

The correct way is like this:

DECLARE @BinaryValue varbinary(MAX)

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

Upvotes: 2

Related Questions