摘要： 本代码适用于: SQLSERVER2000/2005 SQL语句如下： select c.name, t.name as type, c.length ,(case t.name when 'nvarchar' then c.length/2 when 'nchar' then c.length/2 else c.length end) as reallength from syscolumns c join systypes t on c.xtype=t.xtype where t.name 'sysname' and c.id=object_id('Table1') 阅读全文