Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
allan8989
Starting Member
6 Posts |
 Posted - 2008-05-09 : 12:24:48
|
| does anyone know how to check the latest updates to a table? like a new record added or updated or deleted. thanks in advance. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-09 : 12:30:54
|
| With trigger. check DML trigger in BOL. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-09 : 12:45:24
|
quote:
Originally posted by allan8989
does anyone know how to check the latest updates to a table? like a new record added or updated or deleted. thanks in advance.
Two methods. 1.If you want to track these changes at time of occurance and perform some actions, then trigger is the solution.2. If you are looking for synchronising data of another table based on changes in this table at a later time, You just need a procedure to this.Can you please specify your exact requirement? |
|
|
|
allan8964
Posting Yak Master
249 Posts |
Posted - 2008-05-09 : 16:13:38
|
thanks. i am programming something ...but i am not sure what table the codes send the data to. so i think i can try sending something and find what tables are effected, then i know whattables the codes send the records or delete it. would give me somethng detailed. thank you so much. allanquote:
Originally posted by visakh16
quote:
Originally posted by allan8989
does anyone know how to check the latest updates to a table? like a new record added or updated or deleted. thanks in advance.
Two methods. 1.If you want to track these changes at time of occurance and perform some actions, then trigger is the solution.2. If you are looking for synchronising data of another table based on changes in this table at a later time, You just need a procedure to this.Can you please specify your exact requirement?
|
|
|
|
|
|
|
check latest updates