wwwcomcn123的专栏

--创建insert插入类型触发器 create trigger tgr_data_insert on DATA_RECORD_HISTORY for insert --插入触发 as --定义变量 declare @tempValue int; --插入实时值时获取RECORD_VALUE的值 select @tempValue=RECORD_VALUE

SELECT TOP 10 * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY D.RECORD_ID) AS RowNumber,D.RECORD_ID,D.RECORD_VALUE,D.RECORD_TIME,M.CHECK_PROJECT FROM DATA_RECORD_HISTORY D INNER JOIN MONITOR