日期:2014-05-18 浏览次数:20625 次
declare @t table (col ntext) insert into @t select '10002727920 10002727926 10002727927 10002727928 ' union all select '10002727920 10002727926 10002727927 10002727928 ' union all select '10002727920 10002727926 10002727927 10002727928 ' union all select '80002727926 80002727927 80002727928 11111111111 22222222222 ' union all select '80002727920 80002727926 80002727927 80002727928' union all select '10002727920 10002727926 10002727927 10002727928' union all select '13609303497' union all select '18609489876' union all select '18609489876' union all select '10002627920' union all select '10002627920' union all select '10002627920' select sum(ceiling(len(cast(col as varchar(8000)))/12.00)) from @t /* 31 */