uom_migration_script.sql

来自「工厂采购系统,DELPHI+SQL SERVER,三层技术」· SQL 代码 · 共 14 行

insert into GL_Uom_Mstr
(Uom_cd,
 Lang_cd,
 Description,
 alt_nm
)
select 
convert(char(2),Unit),
'EN',
convert(varchar(30),Unit_nm),
convert(varchar(30),Remark)
 from base_unit
where len(unit)=2