- CREATE FUNCTION getPinYin (@str varchar(500) = '')
- RETURNS varchar(500) AS
- /*-------------------用于获取中文名称的首字母---------------------------------*/
- BEGIN
- Declare @strlen int,
- @return varchar(500),
- @ii int,
- @c char(1),
- @chn nchar(1)
- --//初始化变量
- Declare @pytable table(
- chn char(2) COLLATE Chinese_PRC_CS_AS NOT NULL,
- py char(1) COLLATE Chinese_PRC_CS_AS NULL,
- PRIMARY KEY (chn)
- )
- insert into @pytable values('吖', 'A')
- insert into @pytable values('八', 'B')
- insert into @pytable values('嚓', 'C')
- insert into @pytable values('
- --该片段来自于http://www.codesnippet.cn/detail/160120131703.html
来源: http://www.codesnippet.cn/detail/160120131703.html