Posted by Roy Harvey (SQL Server MVP) on 10/24/07 13:19

>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

[Back to original message]