怎樣在sqlserver&mysql中建立漢字拼音對照表

這個不是一句兩句說明白的,不知道你有沒有用過dedecms,

譙城網(wǎng)站制作公司哪家好，找創(chuàng)新互聯(lián)！從網(wǎng)頁設計、網(wǎng)站建設、微信開發(fā)、APP開發(fā)、響應式網(wǎng)站開發(fā)等網(wǎng)站項目制作，到程序開發(fā)，運營維護。創(chuàng)新互聯(lián)自2013年起到現(xiàn)在10年的時間，我們擁有了豐富的建站經(jīng)驗和運維經(jīng)驗，來保證我們的工作的順利進行。專注于網(wǎng)站建設就選創(chuàng)新互聯(lián)。

dedecms建立中文分類,就會自動把漢字轉化為拼音,可以去看一下他的源代碼.

sql中怎么根據(jù)漢字的拼音首字母查詢

--?SQLServer:

---測試數(shù)據(jù)---

if?object_id('[pactinfo]')?is?not?null?drop?table?[pactinfo]

go

create?table?[pactinfo]([ID]?int,[pactname]?varchar(4))

insert?[pactinfo]

select?1,'正常'?union?all

select?2,'中國'?union?all

select?3,'做飯'?union?all

select?4,'加發(fā)'

---引用前輩們的一個函數(shù)---

create?function???f_GetPy(@str???nvarchar(4000))?

returns???nvarchar(4000)?

as?

begin?

declare???@strlen???int,@re???nvarchar(4000)?

declare???@t???table(chr???nchar(1)???collate???Chinese_PRC_CI_AS,letter???nchar(1))?

insert???into???@t(chr,letter)?

select???'吖?',?'A?'???union???all???select???'八?',?'B?'???union???all?

select???'嚓?',?'C?'???union???all???select???'咑?',?'D?'???union???all?

select???'妸?',?'E?'???union???all???select???'發(fā)?',?'F?'???union???all?

select???'旮?',?'G?'???union???all???select???'鉿?',?'H?'???union???all?

select???'丌?',?'J?'???union???all???select???'咔?',?'K?'???union???all?

select???'垃?',?'L?'???union???all???select???'嘸?',?'M?'???union???all?

select???'拏?',?'N?'???union???all???select???'噢?',?'O?'???union???all?

select???'妑?',?'P?'???union???all???select???'七?',?'Q?'???union???all?

select???'呥?',?'R?'???union???all???select???'仨?',?'S?'???union???all?

select???'他?',?'T?'???union???all???select???'屲?',?'W?'???union???all?

select???'夕?',?'X?'???union???all???select???'丫?',?'Y?'???union???all?

select???'帀?',?'Z?'?

select???@strlen=len(@str),@re=?'?'?

while???@strlen?0?

begin?

select???top???1???@re=letter+@re,@strlen=@strlen-1?

from???@t???a???where???chr?=substring(@str,@strlen,1)?

order???by???chr???desc?

if???@@rowcount=0?

select???@re=substring(@str,@strlen,1)+@re,@strlen=@strlen-1?

end?

return(@re)?

end?

---查詢---

select?

*?

from?

[pactinfo]

where

left(dbo.f_GetPy(pactname),1)='Z'

---結果---

ID??????????pactname?

-----------?--------?

1???????????正常

2???????????中國

3???????????做飯

（所影響的行數(shù)為?3?行）

怎樣寫SQL存儲過程漢字轉換拼音簡碼sqlserver2000

使用SQL Server Management Studio在列表中查看即可。 步驟： 1、登錄SQL Server Management Studio。 2、左邊的樹點擊要查詢的庫左邊的“+”，點開后會變成“-”，下同。 3、點擊可編程性-存儲過程

sqlserver語句或者excel公式提取品名漢字拼音碼首字母

要是表格里沒有拼音的話不可能直接根據(jù)中文提取首字母的。EXCEL和SQL還沒智能化到如此