Check Next, Text, the actual length of the image of the image is DATALENGTH (field name)

xiaoxiao2021-03-06  44

Check Next, Text, the actual length of the image of the image is DATALENGTH (field name)

Datalength

Returns the number of bytes occupied by any expression.

grammar

Datales (Expression)

parameter

EXPRESSION

Any type of expression.

Return type

int

Comment

Datales is especially useful to varchar, varbinary, text, image, nvarchar, and ntext data types, because these data types can store variable length data.

The result of NULL DATALENGTH is NULL.

Note The compatibility level may affect the return value. For more information on compatibility, see sp_dbcmptlevel.

转载请注明原文地址:https://www.9cbs.com/read-55552.html

New Post(0)