Click here to Skip to main content
11,711,220 members (81,767 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: SQL-Server
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
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Try to use transaction isolation levels[^]
Rate this: bad
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.

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 549
1 OriginalGriff 255
2 Peter Leow 154
3 Maciej Los 120
4 Abhinav S 120
0 Maciej Los 95
1 Richard MacCutchan 90
2 Abhinav S 90
3 OriginalGriff 80
4 Member 4653839 50

Advertise | Privacy | Mobile
Web02 | 2.8.150819.1 | Last Updated 19 Nov 2012
Copyright © CodeProject, 1999-2015
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