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 |
|
roy_kty
Starting Member
29 Posts |
 Posted - 2007-01-22 : 03:16:31
|
| Dear all,I have a application connect to database and query a view to get data. And use the application update the table involve in the view.However something(sometimes=.="") the view cannot update after I update the table. So may I ask when the view will update itself??Thx for your help!!Roy |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-01-22 : 03:21:37
|
a view is a virtual table. It is actually a query from tables. When the underlying table(s) records are updated, immediately the records selected from the view will reflect the changes.
KH |
 |
|
|
|
|
|
When will view update??