【问】会员档案导入到专卖V8里面,需要更新会员助记码,如何处理? | ||
【适用版本】专卖店8 | 【模块】基本档案 | 【点击数】127 |
【知识编号】Z2012102400004 | ||
【问题描述】会员档案导入到专卖V8里面,需要更新会员助记码,如何处理? |
use isszmv8if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fGetPy]’) and xtype in (N’FN’, N’IF’, N’TF’))drop function [dbo].[fGetPy]GO–创建取拼音函数create function fGetPy(@Str varchar(500)=”)returns varchar(500)asbegin–函数实现开始declare @strlen int,@return varchar(500),@ii intdeclare @n int,@c char(1),@chn nchar(1)select @strlen=len(@str),@return=”,@ii=0set @ii=0while @ii<@strlenbegin select @ii=@ii+1,@n=63,@chn=substring(@str,@ii,1)if @chn>’z’
select @n = @n +1,@c = case chn when @chn then char(@n) else @c end from( select top 27 * from (select chn = ‘吖’union all select ‘八’union all select ‘嚓’union all select ‘咑’union all select ‘妸’union all select ‘发’
union all select ‘旮’union all select ‘铪’union all select ‘丌’ union all select ‘丌’union all select ‘咔’union all select ‘垃’union all select ‘嘸’
union all select ‘拏’union all select ‘噢’union all select ‘妑’union all select ‘七’ union all select ‘呥’union all select ‘仨’union all select ‘他’
union all select ‘屲’ union all select ‘屲’ union all select ‘屲’union all select ‘夕’union all select ‘丫’union all select ‘帀’union all select @chn)
as a order by chn COLLATE Chinese_PRC_CI_AS ) as belse set @c=@chnset @return=@return+@cendreturn(@return)endgo
—-2.对会员卡名字去首字母use isszmv8update t_rm_vip_info set vip_rem=replace(dbo.fgetpy(vip_name),’ ‘,”) where vip_rem=” or vip_rem is null
–3.删除拼音函数drop function fgetpy