train.sql

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

CREATE TABLE Train
  (Tid		Int Primary Key IDENTITY,
   Tno		Varchar(20) Not Null,
   Sstation	Varchar(40),
   Estation	Varchar(40),
   Stime	Varchar(40),
   Etime	Varchar(40),
   PriceYz	Decimal(7, 2),
   PriceRz	Decimal(7, 2),
   PriceYw	Decimal(7, 2),
   PriceRw	Decimal(7, 2),
   Input_time	Char(17)
  )