Size of VARBINARY field in SQL Server 2005

sql sql-server sql-server-2005 clr

Actually, you can do this in T-SQL!

DATALENGTH(<fieldname>) will work on varbinary(max) fields.

sql sql-server sql-server-2005 clr

The VARBINARY(MAX) field allocates variable length data up to just under 2GB in size.

You can use DATALENGTH() function to determine the length of the column content.

For example:

SELECT DATALENGTH(CompanyName), CompanyNameFROM Customers

CodeHunter