DATALENGTH Function ~ Beginner School

DATALENGTH (Transact-SQL)

This function returns the number of bytes used to represent any expression.

Syntax

DATALENGTH ( expression )

Arguments

expression
Is an expression of any data type.

Return Types

bigint if expression is of the varchar(max), nvarchar(max) or varbinary(max) data types; otherwise int.

Remarks

DATALENGTH is especially useful with varchar, varbinary, text, image, nvarchar, and ntext data types because these data types can store variable-length data.
The DATALENGTH of NULL is NULL.

Note

Compatibility levels can affect return values. For more information about compatibility levels, see ALTER DATABASE Compatibility Level (Transact-SQL).

Examples

The following example finds the length of the Name column in the Product table.

USE AdventureWorks2012;
GO
SELECT length = DATALENGTH(Name), Name
FROM Production.Product
ORDER BY Name;
GO

This following example find the length of ID column in Student table:

SELECT length = DATALENGTH(ID), ID
FROM Student
ORDER BY Id;
GO

About Admin

Beginner School is optimized for learning. This is useful for getting basic knowledge with easiest way. Tutorials, examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. With the help of other reference book and website, the motive to provide you easiest way to understand the coding, technology and other things.....

Beginner School