SQLSERVER 检查字段值域并输出行数和值列表

最新推荐文章于 2023-12-26 01:48:36 发布

转载最新推荐文章于 2023-12-26 01:48:36 发布 · 446 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/janehlp/p/4693337.html

文章标签：

#数据库

select * from 
(
SELECT 
'C_DILEI' as fen,'地类' as fcn,
'NVARCHAR'as ftype,
'2'as flen,
(
SELECT count(1) FROM xbmbd WHERE len(ISNULL(C_DILEI,'')) > 2 
) as rnum,
(
SELECT CAST(C_DILEI AS VARCHAR(50))+',' FROM xbmbd WHERE len(ISNULL(C_DILEI,'')) > 2 GROUP BY C_DILEI ORDER BY C_DILEI for xml path('')
 ) as fval
) t where fval is not null

输出结果如下: