如何批量获取text字段的长度 - MSSQL教程

select MAX (DATALENGTH (paybeizhu )) as paybeizhu,

MAX(DATALENGTH (Flighty2 )) as Flighty2,

MAX(DATALENGTH (Flighty1 )) as Flighty1,

MAX(DATALENGTH (remarks )) as remarks,

MAX(DATALENGTH (rinfo )) as rinfo,

MAX(DATALENGTH (rlog )) as rlog

from dbo.Orders with(nolock)

go

查看本栏目更多精彩内容：http://www.bianceng.cn/database/SQLServer/

（编辑：应用网_镇江站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!