查询在5秒内从数据库中获取记录 [英] Query to fetch record from database within 5 seconds

问题描述

假设这是我的表，其中每秒插入记录，现在我想从此表中获取记录或TagID，不断插入数据库中

或

其TagID在5秒内插入数据库

这里TagId Q11重复插入数据库。

所以我想要一个可以检索记录或TagId的查询或函数从数据库中不断插入5个secon

请帮助我..................



TagID天线   DATETIME



Q11   1   07/23/2014 11:10:01 pm

Q11   1   07/23/2014 11:10:02 pm

Q11   1   07/23/2014 11:10:03 pm

Q11   1   07/23/2014 11:10:04 pm

Q11   1   07/23/2014 11:10:05 pm

Q11   1   07/23/2014 11:10:06 pm

Q11   1   07/23/2014 11:10:07 pm

Q11   1   2014年7月23日下午11:10:08

Q22   2   07/23/2014 11:10:09 pm

Q22   2   2014年7月23日下午11:10:10

Q22   2   07/23/2014 11:10:12 pm

Q22   2   07/23/2014 11:10:13 pm

推荐答案

这将是您的解决方案

This will be your solution

CREATE Table #Temp2(TagId varchar(5),Antenna INT,DT varchar(30))
SELECT * INTO #Temp from
(
	Select 'Q11' as TagID,1 as Antenna,'07/23/2014 11:10:01 pm' as DT
	UNION
	Select 'Q11' as TagID,1 as Antenna,'07/23/2014 11:10:02 pm' as DT
	UNION
	Select 'Q11' as TagID,1 as Antenna,'07/23/2014 11:10:03 pm' as DT
	UNION
	Select 'Q11' as TagID,1 as Antenna,'07/23/2014 11:10:04 pm' as DT
	UNION
	Select 'Q11' as TagID,1 as Antenna,'07/23/2014 11:10:05 pm' as DT
	UNION
	Select 'Q11' as TagID,1 as Antenna,'07/23/2014 11:10:06 pm' as DT
	UNION
	Select 'Q11' as TagID,1 as Antenna,'07/23/2014 11:10:07 pm' as DT
	UNION
	Select 'Q11' as TagID,1 as Antenna,'07/23/2014 11:10:08 pm' as DT
	UNION
	Select 'Q22' as TagID,2 as Antenna,'07/23/2014 11:10:09 pm' as DT
	UNION
	Select 'Q22' as TagID,2 as Antenna,'07/23/2014 11:10:10 pm' as DT
	UNION
	Select 'Q22' as TagID,2 as Antenna,'07/23/2014 11:10:11 pm' as DT
	UNION
	Select 'Q22' as TagID,2 as Antenna,'07/23/2014 11:10:12 pm' as DT
	UNION
	Select 'Q22' as TagID,2 as Antenna,'07/23/2014 11:10:13 pm' as DT
	
) as A

Declare @i INT = 0
DECLARE @T as DateTime
SELECT @T = min(DT) FROM #TEMP (NOLOCK)

WHILE @i < (select count(*) FROM #Temp (NOLOCK))
BEGIN
	INSERT INTO #Temp2
		Select * FROM #Temp (NOLOCK) Where cast(DT as DATETIME) = @T
		SET @i = @i+1
		SET @T = dateadd(ss,5,@T)
	
END

SELECT * FROM #Temp2
Drop TABLE #Temp2
Drop TABLE #Temp

这篇关于查询在5秒内从数据库中获取记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！