Monday, February 27, 2012

difference between len and datalength

DATALENGTH() returns length of string in bytes, including trailing spaces. LEN() returns length of  string in characters excluding trailing spaces.


 

One more difference  varchar vs nvarchar with sql server 


No comments:

Post a Comment