Top "Datalength" questions

DATALENGTH is a T-SQL function in SQL Server 2005+ which takes any column or variable, and returns the length of the data in bytes.

count number of characters in nvarchar column

Does anyone know a good way to count characters in a text (nvarchar) column in Sql Server? The values there …

sql sql-server-2008 datalength
What is the size of a image field content in SQL Server?

I have a table in SQL Server. This table has an image field and the application stores files in it. …

sql-server tsql datalength
SQL Server 2008 Empty String vs. Space

I ran into something a little odd this morning and thought I'd submit it for commentary. Can someone explain why …

sql-server sql-server-2008 tsql string-length datalength
Length of varbinary(max) filestream on SQL Server 2008

Is there some efficient way how to get length of data in "varbinary(max) filestream" column? I found only samples …

sql-server filestream varbinary datalength