Can we update View
am 17.11.2007 09:48:53 von khaleel ahamed karnalnhffgh
Re: Can we update View
am 18.11.2007 21:50:13 von Joe CelkoNo; you update the base table(s) that build the VIEW. The VIEW does
not exist in the schema. Google the subject.
Re: Can we update View
am 19.11.2007 05:42:03 von Ed Murphy--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