tline.sql

来自「采用VisualBasic和SQL Server 2000开发 功能比较全面的」· SQL 代码 · 共 13 行

CREATE TABLE tline
  (lid		Int Primary Key,
   lname	Varchar(50),
   lday		Smallint,
   ltype	Smallint,
   insCom	Varchar(40),
   insFee	Decimal(8, 2),
   otherCost	Decimal(8, 2),
   tourPay	Decimal(8, 2),
   benefit	Decimal(8, 2),
   AreaId	Int
  )