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 ?

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

On Oct 22, 8:26 am, Phung <pu...@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 ?

Neither. The contents of a view are not stored, so there is no
"updating" to be done. Just know that when you select from the view
it will always reflect the current state of the base tables at that
moment.

>On Oct 22, 8:49 pm, "Roy Harvey (SQL Server MVP)"
><roy_har...@snet.net> wrote:
>> On Mon, 22 Oct 2007 05:26:37 -0700, Phung <pu...@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
>
>thank you. that means the process is done when we select the view.
>but, if i want "updating" then i should create a trigger or stored
>procedure to update the data stored in a table instead of a view, is
>it right ?

Please keep the discussion the news group, not email.

Some views can be updated, but it is more usual to update the
underlying table. Certainly triggers can only be placed on a physical
table, and I would normally only update physical tables.

Roy Harvey
Beacon Falls, CT