各位大神,用这段代码写个触发器!
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]