tb_gl_currexchg_rate.sql

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

IF object_id('dbo.GL_CurrExchg_Rate') is not null
drop table dbo.GL_CurrExchg_Rate
go

create table GL_CurrExchg_Rate
(
  Currency   CHAR(3)  NOT NULL constraint fk_currency  references GL_Currency_Mstr(currency),
  Rate       numeric(18,8) not null default 1.000000,
  Vaild_from datetime not null default getdate(),
  deadLine   datetime not null default getdate(),
  Active     bit null default 0
)
go

insert into GL_CurrExchg_Rate(Currency,Rate,Vaild_From,DeadLine)
select currency,0.0000,getdate(),'2008-01-18' from gl_currency_mstr