app.sql

来自「一个简单的酒店管理系统 用VB.net+SQL2000实现」· SQL 代码 · 共 26 行

CONNECT TO s_hdxt;
CREATE TABLE Issues
(
	CUSIP varchar (8) NULL ,
	Ticker varchar (7) NULL ,
	Name varchar (50) NULL,
        CONSTRAINT PK___1__16 PRIMARY KEY
        (
                  CUSIP
        )
);
CREATE TABLE Quotes
(
	Ticker varchar (50) NULL ,
	Date datetime NULL ,
	Volume int NULL ,
	HighAsk varchar (50) NULL ,
	LowBid varchar (50) NULL ,
	CloseAvg varchar (50) NULL,
        CONSTRAINT PK___2__16 PRIMARY KEY
        (
                 Ticker,
                  Date
        )
);