H1医保刷卡字段超长

wbv123

———–在门店数据库执行
——–1.字段长度更新代码
ALTER TABLE t_yby_order_h ALTER COLUMN institutionname varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN institutioncode varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN ext_char01 varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN ext_char02 varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN ext_char03 varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN ext_char04 varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN ext_char06 varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN ext_char07 varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN ext_char08 varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN ext_char09 varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN ext_char10 varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN ext_char11 varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN ext_char12 varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN ext_char13 varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN ext_char14 varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN ext_char15 varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN ext_char16 varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN ext_char17 varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN ext_char18 varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN ext_char19 varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN ext_char20 varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN ext_char21 varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN ext_char22 varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN ext_char23 varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN ext_char24 varchar(1000)
ALTER TABLE t_yby_order_h ALTER COLUMN ext_char25 varchar(1000)

—-添加字段
select * from T_MEDICARE_CLOUD_ORGAN

alter table T_MEDICARE_CLOUD_ORGAN alter column erpmedicalname varchar(255)

alter table T_MEDICARE_CLOUD_ORGAN alter column medicalname varchar(255)

——加D表字段长度
ALTER TABLE t_yby_order_d ALTER COLUMN specs varchar(500)
ALTER TABLE t_yby_order_d ALTER COLUMN manufacturer varchar(500)
ALTER TABLE t_yby_order_d ALTER COLUMN centeritemcode varchar(500)
ALTER TABLE t_yby_order_d ALTER COLUMN supplyno varchar(500)
ALTER TABLE t_yby_order_d ALTER COLUMN insurancecategory varchar(500)
ALTER TABLE t_yby_order_d ALTER COLUMN ext_char01 varchar(500)
ALTER TABLE t_yby_order_d ALTER COLUMN ext_char02 varchar(500)
ALTER TABLE t_yby_order_d ALTER COLUMN ext_char03 varchar(500)
ALTER TABLE t_yby_order_d ALTER COLUMN ext_char04 varchar(500)
ALTER TABLE t_yby_order_d ALTER COLUMN ext_char05 varchar(500)
ALTER TABLE t_yby_order_d ALTER COLUMN ext_char06 varchar(500)
ALTER TABLE t_yby_order_d ALTER COLUMN ext_char07 varchar(500)
ALTER TABLE t_yby_order_d ALTER COLUMN ext_char08 varchar(500)
ALTER TABLE t_yby_order_d ALTER COLUMN ext_char09 varchar(500)
ALTER TABLE t_yby_order_d ALTER COLUMN ext_char10 varchar(500)
ALTER TABLE t_yby_order_d ALTER COLUMN ext_char11 varchar(500)
ALTER TABLE t_yby_order_d ALTER COLUMN ext_char12 varchar(500)
ALTER TABLE t_yby_order_d ALTER COLUMN ext_char13 varchar(500)
ALTER TABLE t_yby_order_d ALTER COLUMN ext_char14 varchar(500)
ALTER TABLE t_yby_order_d ALTER COLUMN ext_char15 varchar(500)