CODEWITHSUNDEEP
sqlsql-serverreal-time
gaijintendo
gaijintendo

Reputation: 423

Can you view the contents of a SQL (Server) table in realtime?

Is it possible to have a table or view which updates in real-time - so I can see the changes without refreshing?

The nearest thing I ever found was

raiserror('',0,1) with nowait --to flush the buffer
print 'hello'                 --say hello
waitfor delay '00:00:01'      --pause for 1 second
GO 5                          --loop 5 times

but obviously using that for a select gives you multiple tables rather than refreshing the table

Upvotes: 1

Views: 2165

Answers (1)

Remus Rusanu
Remus Rusanu

Reputation: 294307

Query Notifications can update you in real time when changes in the table occur, but you will have to query again the table to see what changed. At the least it eliminates pooling. As a cache-invalidation solution, is intended to be used with relatively static data that changes seldom.

For frequent changing data the best is to poll and have a way to return only the changes (eg. updated_at) but is rather trickier to detect deletes.

Change Data Capture is a technology that will record changes (and makes discovery of deletes trivial) and you can query for the changes, but is intended for occasionally connected systems (eg. Phones updating the local snapshot from the mothership database), not for live change monitoring.

Upvotes: 1

Related Questions