Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server
Hi,
Iam stuck with my work due to this problem.I searched in the net and very hard to find a solution.The problem is,I have a table in my database which is getting filled with data in every 5 seconds.I need to write a stored procedure to take data every 5 sec and doing some calculations.Iam unable to fetch continuously changing(continuously getting filled)) datas from my table.Is anybody have any idea about doing that?
Posted 18-Nov-12 20:21pm
danil33399
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Try to use transaction isolation levels
http://msdn.microsoft.com/en-us/library/ms173763.aspx[^]
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Stored Procedure can execute set of queries and/or return result to caller. It can't run repeatedly.
But you can call SP from application side after some interval using timercontrol or like this.
Be careful, it will slow down your application if you fetch data frequently (depending on data volume).
It will be better store modification datetime on table and fetch data depending on that field, it will decrease traffic and faster your application.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Mobile
Web01 | 2.8.141015.1 | Last Updated 19 Nov 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100