轉自:http://www.maomao365.com/?p=6421
摘要:
下文講述計算漢字筆畫數的sql函式分享，如下所示:
例:建立漢字筆畫數sql函式
create function [dbo].[fn_hanZiBiHuaShu](@char nchar(2)) returns int as begin return( case when unicode(@char) between 19968 and 40869 then( select top 1 id from( select id=1,ch=N`亅` union all select 2,N`阝` union all select 3,N`馬` union all select 4,N`風` union all select 5,N`龍` union all select 6,N`齊` union all select 7,N`龜` union all select 8,N`齒` union all select 9,N`鴆` union all select 10,N`齔` union all select 11,N`龕` union all select 12,N`齗` union all select 13,N`齠` union all select 14,N`齦` union all select 15,N`齪` union all select 16,N`龍` union all select 17,N`龠` union all select 18,N`龎` union all select 19,N`龐` union all select 20,N`龑` union all select 21,N`龡` union all select 22,N`龢` union all select 23,N`龝` union all select 24,N`齹` union all select 25,N`龣` union all select 26,N`龥` union all select 27,N`齈` union all select 28,N`龞` union all select 29,N`麷` union all select 30,N`鸞` union all select 31,N`麣` union all select 32,N`龖` union all select 33,N`龗` union all select 35,N`齾` union all select 36,N`齉` union all select 39,N`靐` union all select 64,N`龘` )a where ch>=@char collate Chinese_PRC_Stroke_CS_AS_KS_WS order by id ASC) else 0 end) end go --測試獲取漢字筆畫數的sql函式 select dbo.[fn_hanZiBiHuaShu](`貓`) drop function dbo.[fn_hanZiBiHuaShu] go