tb_gl_currency_mstr.sql

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

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

Create table GL_Currency_Mstr
(
Currency	CHAR(3) not null constraint pk_gl_currency  primary key,
Description    varchar(30) null,
lang_cd		CHAR(3) null default 'ENG',
Rate numeric(18,8) not null default 0.000000,
Active  bit not null default 0,
alt_nm          varchar(30) null,
)

go

insert into GL_Currency_Mstr(Currency,alt_nm,Lang_cd,Rate,active)
select curr_E,curr_name,'EN',curr_rate,0 from currency