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