Re: Can we update View

#1

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

#2

--CELKO-- wrote:

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Can we update View

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Re: Can we update View - 11-18-2007 , 02:50 PM

Re: Can we update View - 11-18-2007 , 10:42 PM