在固定资产清单和固定资产折旧明细表中部分固定资产折卡片列错位

在固定资产清单和固定资产折旧明细表中部分固定资产折卡片列错位

在固定资产清单和固定资产折旧明细表中部分固定资产折卡片列错位

在录入固定资产卡片的时候,固定资产名称,编码,规格型号录入了回车,换行,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

分享到 :
相关推荐

Leave a Reply

Your email address will not be published. Required fields are marked *