SQL DATALENGTH

The SQL Server DATALENGTH is used to return the number of bytes used to represent a specified expression. The syntax of DATALENGTH is SELECT DATALENGTH (String_Expression) FROM [Source] This SQL DATALENGTH function is useful for VARCHAR, NVARCHAR, VARBINARY, TEXT, NTEXT, and IMAGE Data Types because these data types will store the data length. For this … Read more