tb_gl_parameter_mstr.sql

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

use qai
go

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

Create table GL_Parameter_Mstr
(
	Param_Code   CHAR(4) NOT NULL,
	Param_Value  int not null default 0,
	Description  varchar(120) not null,
	Alt_nm	     varchar(120) null,
 	Active       bit not null default 0,
	valid	     datetime not null default getdate(),
	Expiration_dt datetime not null default getdate()
)

go
	insert into GL_Parameter_Mstr(Param_Code,Param_Value,Description,alt_nm,active,valid,expiration_dt)
	values('P001',1,'Delivery Delay Alter','交货延时提醒',1,getdate(),'2008-12-31')