Can we update View

nhffgh
khaleel ahamed karnal [ Sa, 17 November 2007 09:48 ] [ ID #1873105 ]

Re: Can we update View

No; you update the base table(s) that build the VIEW. The VIEW does
not exist in the schema. Google the subject.
Joe Celko [ So, 18 November 2007 21:50 ] [ ID #1873592 ]

Re: Can we update View

--CELKO-- wrote:

> No; you update the base table(s) that build the VIEW. The VIEW does
> not exist in the schema. Google the subject.

To clarify: you can sometimes run INSERT, UPDATE, and DELETE against
a view, which gets translated into the same operation against one of
the base tables. See http://doc.ddart.net/mssql/sql70/create_9.htm
Ed Murphy [ Mo, 19 November 2007 05:42 ] [ ID #1874193 ]
Datenbanken » comp.databases.ms-sqlserver » Can we update View

Vorheriges Thema: Backup Files
Nächstes Thema: bcp to xml