SQLSERVER :LEN,DataLength,Col_Length

 

代码

CREATE TABLE [ dbo ] . [ OrderDetail ] (
[ ID ] [ bigint ] NOT NULL ,
[ NameVarchar ] [ varchar ] ( 6 ) NULL ,
[ NameNVarchar ] [ nvarchar ] ( 60 ) NULL
) ON [ PRIMARY ]


INSERT INTO [ OrderDetail ] (ID,NameVarchar,NameNVarchar) VALUES ( 1 , ' 111 ' , ' 你好啊 ' )

select ID, LEN (ID),
NameVarchar, LEN (NameVarchar),
NameNVarchar, LEN (NameNVarchar)
FROM ORDERDetail


select ID, DataLENGTH (ID),
NameVarchar, DataLENGTH (NameVarchar),
NameNVarchar, DataLENGTH (NameNVarchar)
FROM ORDERDetail

select COL_LENGTH ( ' ORDERDetail ' , ' ID ' ),
COL_LENGTH ( ' ORDERDetail ' , ' NameVarchar ' ),
COL_LENGTH ( ' ORDERDetail ' , ' NameNVarchar ' )

转载于:https://www.cnblogs.com/ptwlw/archive/2010/11/28/1890214.html