Search code examples
sql-server-2008varbinary

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)

Solution

  • The correct way is like this:

    DECLARE @BinaryValue varbinary(MAX)
    

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