Updating views sql server

Since views are just SQL select statements, there are a few restrictions on which views can update data back to the tables.

Updatable views can modify more than one table involved in the view.This trigger allows the user to specify the set of actions that need to take place in order to process the data modification statement.Thus, if an INSTEAD OF trigger exists for a view on a given data modification statement (INSERT, UPDATE, or DELETE), the corresponding view is updatable through that statement. You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. Can u please tell me whether we can insert/update and delete the views.This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. As views are like virtual table then can we do the manipulations in the view excluding retrieval.

Search for updating views sql server:

updating views sql server-11updating views sql server-37

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “updating views sql server”

  1. Instant free webcam chat with thousands of people from all over the world. Login as a guest for free access or choose to register a member account to secure your name for your return visit to the chat rooms. If the chat service does not initialize in the browser please install our desktop version from the link further down on this page.