代码改变世界

SQLSERVER :LEN,DataLength,Col_Length

2010-11-28 14:34  2323  阅读(337)  评论(0)  编辑  收藏  举报

 

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