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 |
|
dasu
Posting Yak Master
104 Posts |
 Posted - 2004-09-17 : 00:49:51
|
| Hello every body, how to count number of updates (not updated records count) on a table here asume a row may be updated twice then how can i get the total no of updations in particulartableplease help me about this issue.regardsdasu.g |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-17 : 00:58:28
|
| is this on a per day basis?1. create an audit table saving the record primary key (unique key),date updated and counter 2. create a trigger for updates, saving into the audit tableorif it's important that you get the data updated, then you can just redesign the audit table and save each update then query for the count based on your criteriajust some ideas... |
 |
|
|
|
|
|
how to count no of updated records