在固定资产清单和固定资产折旧明细表中部分固定资产折卡片列错位
在录入固定资产卡片的时候,固定资产名称,编码,规格型号录入了回车,换行,TAB,空格等非法字符. 一般情况下，从哪一列开始错位，可以考虑检查该列的前一列字段是否有非法字符。
--去掉固定资产名称中的非法字符：
update t_facard set fassetname=replace(fassetname,' ','') where
charindex(' ',fassetname)>0
update t_facard set fassetname=replace(fassetname,' ','') where
charindex(' ',fassetname)>0
update t_facard set fassetname=replace(fassetname,char(10),'') where
charindex(char(10),fassetname)>0
update t_facard set fassetname=replace(fassetname,char(13),'') where
charindex(char(13),fassetname)>0
update t_facard set
fassetname=replace(fassetname,char(13)+char(10),'') where
charindex(char(13)+char(10),fassetname)>0
update t_fabalcard set fassetname=replace(fassetname,' ','') where
charindex(' ',fassetname)>0
update t_fabalcard set fassetname=replace(fassetname,' ','') where
charindex(' ',fassetname)>0
update t_fabalcard set fassetname=replace(fassetname,char(10),'')
where charindex(char(10),fassetname)>0
update t_fabalcard set fassetname=replace(fassetname,char(13),'')
where charindex(char(13),fassetname)>0
update t_fabalcard set
fassetname=replace(fassetname,char(13)+char(10),'') where
charindex(char(13)+char(10),fassetname)>0
--去掉固定资产编码中的非法字符：
update t_facard set fassetnumber=replace(fassetnumber,' ','') where
charindex(' ',fassetnumber)>0
update t_facard set fassetnumber=replace(fassetnumber,' ','') where
charindex(' ',fassetnumber)>0
update t_facard set fassetnumber=replace(fassetnumber,char(10),'')
where charindex(char(10),fassetnumber)>0
update t_facard set fassetnumber=replace(fassetnumber,char(13),'')
where charindex(char(13),fassetnumber)>0
update t_facard set
fassetnumber=replace(fassetnumber,char(13)+char(10),'') where
charindex(char(13)+char(10),fassetnumber)>0
update t_fabalcard set fassetnumber=replace(fassetnumber,' ','') where
charindex(' ',fassetnumber)>0
update t_fabalcard set fassetnumber=replace(fassetnumber,' ','') where
charindex(' ',fassetnumber)>0
update t_fabalcard set fassetnumber=replace(fassetnumber,char(10),'')
where charindex(char(10),fassetnumber)>0
update t_fabalcard set fassetnumber=replace(fassetnumber,char(13),'')
where charindex(char(13),fassetnumber)>0
update t_fabalcard set
fassetnumber=replace(fassetnumber,char(13)+char(10),'') where
charindex(char(13)+char(10),fassetnumber)>0
--去掉固定资产规格型号中的非法字符：
update t_facard set fmodel=replace(fmodel,' ','') where charindex('
',fmodel)>0
update t_facard set fmodel=replace(fmodel,' ','') where charindex('
',fmodel)>0
update t_facard set fmodel=replace(fmodel,char(10),'') where
charindex(char(10),fmodel)>0
update t_facard set fmodel=replace(fmodel,char(13),'') where
charindex(char(13),fmodel)>0
update t_facard set fmodel=replace(fmodel,char(13)+char(10),'') where
charindex(char(13)+char(10),fmodel)>0
update t_fabalcard set fmodel=replace(fmodel,' ','') where charindex('
',fmodel)>0
update t_fabalcard set fmodel=replace(fmodel,' ','') where charindex('
',fmodel)>0
update t_fabalcard set fmodel=replace(fmodel,char(10),'') where
charindex(char(10),fmodel)>0
update t_fabalcard set fmodel=replace(fmodel,char(13),'') where
charindex(char(13),fmodel)>0
update t_fabalcard set fmodel=replace(fmodel,char(13)+char(10),'')
where charindex(char(13)+char(10),fmodel)>0
文章评论