摘要：老竞驰管理通大掌柜商贸版升级到总舵主通用版后，没有客户资料的话，执行一下代码 ，会出现 截断字符串等提示，就是因为名字位数不够造成的，执行下面的代码后，再升级即可insert into basunittypeinner (baseno, parentno, b

老竞驰管理通大掌柜商贸版升级到总舵主通用版后，没有客户资料的话，执行一下代码 ，会出现 截断字符串等提示，就是因为名字位数不够造成的，执行下面的代码后，再升级即可

insert into basunittypeinner (baseno, parentno, basecode, name, IniArTotal,IniAPTotal,IniPrepayARTotal,IniPrepayAPTotal,

fullname, unitphone,faxnum , pyno,address,PostCode,linkman )

select id,par_id,code,name,ystotal00, yftotal00,yushoutotal00,yufutotal00,

fullname, tel,'' ,pym,addr,postcode,person

from aaa..t_base_wldw where id > 4

ALTER TABLE BasPtypeInner alter column [BaseCode] [varchar](100) null

ALTER TABLE BasPtypeInner alter column [Name] [varchar](800) NULL

ALTER TABLE BasPtypeInner alter column [FullName] [varchar](800) NULL

ALTER TABLE BasPtypeInner alter column [Standards] [varchar](100) NULL

ALTER TABLE BasPtypeInner alter column [Model] [varchar](100) NULL

ALTER TABLE BasPtypeInner alter column [ProArea] [varchar](100) NULL

ALTER TABLE BasPtypeInner alter column [BasicUnit] [varchar](100) NULL

ALTER TABLE BasPtypeInner alter column [AssistUnitOne] [varchar](100) NULL

ALTER TABLE BasPtypeInner alter column [AssistUnitTwo] [varchar](100) NULL

ALTER TABLE BasPtypeInner alter column [AssistUnitThree] [varchar](100) NULL

ALTER TABLE BasPtypeInner alter column [PyNo] [varchar](100) NULL

ALTER TABLE BasUnitTypeInner alter column [BaseCode] [varchar](50) NULL

ALTER TABLE BasUnitTypeInner alter column [Name] [varchar](100) NULL

ALTER TABLE BasUnitTypeInner alter column [FullName] [varchar](100) NULL

ALTER TABLE BasUnitTypeInner alter column [Address] [varchar](200) NULL

ALTER TABLE BasUnitTypeInner alter column [UnitPhone] [varchar](100) NULL

ALTER TABLE BasUnitTypeInner alter column [LinkMan] [varchar](100) NULL

ALTER TABLE BasUnitTypeInner alter column [LinkPhone] [varchar](100) NULL

UPDATE BASPTYPEINNER SET MODEL =standards --型号等用户规格

update SysData set SubValue='DIY' WHERE SubNo=18

SELECT * FROM BasPtypeInner WHERE model LIKE '%*%'

select * from BasPtypeInner where model like '%cm%'

update BasPtypeInner set Model='' where model like '%cm%'

SELECT SUBSTRING(model, 2, LEN(model)) as model FROM BASPTYPEINNER WHERE model LIKE '%*%'

--去掉规格前2位

update basptypeinner set model = SUBSTRING(model, 3, LEN(model)) FROM BASPTYPEINNER WHERE model LIKE '%*%'

update basptypeinner set model = SUBSTRING(model, 3, LEN(model)) FROM BASPTYPEINNER WHERE model LIKE '%*%'

update basptypeinner set model = SUBSTRING(model, 2, LEN(model)) FROM BASPTYPEINNER WHERE model LIKE '%*%'

SELECT SUBSTRING(model, LEN(model) - 1, 2) AS last_two_characters FROM BASPTYPEINNER---去掉规格前2位，并更新规格

update BasPtypeInner set PercentOne=model where model>1

UPDATE BasPtypeInner SET AssistUnitTwo=''

UPDATE BasPtypeInner SET AssistUnitThree=''

update basptypeinner set model=SUBSTRING(model, LEN(model) - 1, 1) FROM BASPTYPEINNER---取规格后2位，并更新规格

alter table basptypeinner add [stopdate] varchar(10) null

ALTER VIEW [dbo].[BasPtype] AS SELECT a.* FROM dbo.BasPtypeInner a

GO

来源：左手吴