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 |
|
dlash
Starting Member
2 Posts |
 Posted - 2004-09-28 : 13:08:38
|
| HiI am trying to figure out how to query an SQL server database for only the rows of a view that have changed (since my last query). Is there any way to access just these changed rows? Thanksdlash |
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2004-09-28 : 13:12:15
|
| Does the table contain a Modified Date Field storing GetDate() after each record change? Are you running an Application to store the DateTime of the Fetch?Surf On Dude! |
 |
|
|
dlash
Starting Member
2 Posts |
Posted - 2004-09-28 : 13:21:51
|
| The table/view does not have the store the data/time of each change. I can store the DateTime of the fetch in the Application |
|
|
|
Richard Branson
Yak Posting Veteran
84 Posts |
Posted - 2004-10-01 : 04:54:09
|
| How do you know that the underlying table in your view has changed since your last query?You can't teach an old mouse new clicks. |
|
|
|
|
|
|
Extracting Only Changed Rows of A View