|
|
Posted by Roy Harvey (SQL Server MVP) on 10/22/07 13:49
On Mon, 22 Oct 2007 05:26:37 -0700, Phung <purwa@purwadhika.com>
wrote:
>Hi friend ! i want to ask you about view. will the view data be
>updated automatically when we insert or update the physical table or
>it is updated when we execute the view ?
The view data IS the table data. When you reference a view in a
SELECT, the SELECT command inside the view and the SELECT (or other
command) using the view are combined into a more complex SELECT, and
the underlying tables are read.
Roy Harvey
Beacon Falls, CT
Navigation:
[Reply to this message]
|