sqlserver表（期权）

甲骨文数据库

于 2025-04-02 01:43:12 发布

阅读量124

点赞数 2

CC 4.0 BY-SA版权

文章标签： sql 数据库 java

本文链接：https://blog.youkuaiyun.com/www_oracle_com/article/details/146927855

USE [wenhua2020]



create table t_1(
	id bigint identity(1,1) not null,
	TradingDay date not null default getdate(),
	InstrumentID nvarchar(max) not null default '',
	LastPrice decimal(18, 2) not null default 0,
	PreClosePrice decimal(18, 2) not null default 0,
	OpenPrice decimal(18, 2) not null default 0,
	HighestPrice decimal(18, 2) not null default 0,
	LowestPrice decimal(18, 2) not null default 0,
	UpdateTime time(0) not null default getdate(),
	Volume int not null default 0,
	LowerLimitPrice decimal(18, 2) not null default 0,
	primary key(id)
)

select count(*) from t_1
select * from t_1 order by id desc
delete from t_1