注册 登录
编程论坛 SQL Server论坛

各位大神,用这段代码写个触发器!

tanghf1014 发布于 2013-03-27 20:43, 591 次点击
CREATE TABLE [dbo].[MIN_LATEST_IF](    [InstrumentID] [varchar](20) NOT NULL,    [TradingDay] [datetime] NOT NULL,    [TradingTime] [datetime] NOT NULL,    [Openprice] [float] NULL,    [Highprice] [float] NULL,    [Lowprice] [float] NULL,    [Closeprice] [float] NULL,    [Vol] [bigint] NULL,    [Opi] [bigint] NULL,    [settlementprice] [float] NULL,    [TotVol] [bigint] NULL, CONSTRAINT [PK__JYSJ_FZ___3CCC3C5636470DEF] PRIMARY KEY CLUSTERED (    [TradingDay] ASC,    [InstrumentID] ASC,    [TradingTime] ASC) WITH (PAD_INDEX =OFF,STATISTICS_NORECOMPUTE =OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS =ON,ALLOW_PAGE_LOCKS =ON) ON [PRIMARY] ) ON [PRIMARY]
1 回复
#2
tanghf10142013-03-27 20:44
不过运行的时候有个错误,求解
1