sql

select
    sum(LEN(text)),
    sysobjects.name,
    COUNT(*)
from
    sysobjects  inner join syscomments
    on
        sysobjects.id = syscomments.id   
where xtype = 'P'
    and syscomments.encrypted = 0
group by
    sysobjects.name
order by
    sum(LEN(text))

统计sql proc内容的长度。加密的不能统计,另

posted on   聪明的大熊  阅读(137)  评论(0编辑  收藏  举报
努力加载评论中...

点击右上角即可分享
微信分享提示