批量获取text字段的长度

最新推荐文章于 2018-07-19 11:40:58 发布

iteye_6233

最新推荐文章于 2018-07-19 11:40:58 发布

阅读量109

点赞数

文章标签： java

项目，需要批量转换text到varchar，需要批量获取varchar长度.

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