代码
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 ' )
[ 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 ' )