Title: SQL views are always updatable when ________. Post by: lmalma on Feb 13, 2019 SQL views are always updatable when ________.
• the view is based on a single table with no computed columns, and all non-null columns are present in the view • the view is based on any number of tables, with or without computed columns, and the INSTEAD OF trigger is defined for the view • the view is based on multiple tables, the update is being done on the most subordinate table, and the rows of that table can be uniquely identified • Both the view is based on a single table with no computed columns, and all non-null columns are present in the view and the view is based on any number of tables, with or without computed columns, and the INSTEAD OF trigger is defined for the view are correct Title: SQL views are always updatable when ________. Post by: peaceout3000 on Feb 13, 2019 Content hidden
Title: SQL views are always updatable when ________. Post by: lmalma on Feb 13, 2019 Smart ... Thanks!
|