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.