Database Explorer
Sunday, 22 February 2015
DataLength for Nvarchar Column Check
SELECT
DATALENGTH
(
[DATEUPLOADED]
),
[DATEUPLOADED]
FROM
[DBName]
.
[dbo]
.
[T_TableName]
WHERE
DATALENGTH
(
[DATEUPLOADED]
)
<>
20
In the nvarchar column, one word refers to 2 bytes per character. Therefore, 10 words in date format refers to 20.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment