tb_gl_uom_mstr.sql

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

if object_id('dbo.GL_UoM_Mstr') is not null
drop table dbo.GL_UoM_Mstr
go

Create table GL_UoM_Mstr
(
 Uom_cd		char(3) not null constraint pk_uom_mstrx primary key,
 Dim_cd		varchar(15) null, 
 iso_cd 	varchar(15) null,
 Description    varchar(30) null,
 Alt_nm		varchar(30) null,
 Lang_cd	char(3) null default 'EN'
)
go
 

insert into GL_UoM_mstr(Uom_cd,iso_cd,description,alt_nm,lang_cd)

select distinct Uom_cd,iso_cd,description,alt_nm,'EN' from import_uom_upload

select uom_cd from import_uom_upload