---�޸����Ĉ��ģ�K���a liujuncheng create 20120214
---��ȡ����ģ�K���a�����ĵ�ģ�K��Ϣ
select *
into #nn
from tb_module
where patindex('%[߹-��]%',c_code)>0

---select * from #nn
---�h������Ҫ�{���Ĉ��
delete #nn
where c_code in ('kkkkkk������','�úóԵIJ�Ŷ')

---�����R�r��,����µľ��a���ϵľ��a
create table #mm
(c_newcode varchar(300),
c_code varchar(300),
c_name varchar(300),
c_cname varchar(300))

---�����µ�ģ�K���a
insert into #mm(c_newcode,c_code,c_name,c_cname)
select newid(),c_code,c_name,c_cname
from #nn

---�޸�ģ�K���a
update tb_module set c_code = #mm.c_newcode
from #mm
where tb_module.c_name = #mm.c_name
and tb_module.c_code = #mm.c_code

---�޸IJˆΌ�����ģ�K���a
update tb_menu set c_mdcode = #mm.c_newcode
from #mm
where tb_menu.c_mdcode = #mm.c_code

---�޸��Ñ������е�ģ�K���a
update tb_mdlimit set c_mdcode = #mm.c_newcode
from #mm
where tb_mdlimit.c_mdcode = #mm.c_code

---�޸��Ñ��M�����е�ģ�K���a
update tb_mdlimit_group set c_mdcode = #mm.c_newcode
from #mm
where tb_mdlimit_group.c_mdcode = #mm.c_code