Answer Posted / gunjan sapra
View is a virtual table,created by users for their own
convienience.
views can be updated as required but the updated data will
not reflect in the base table, since view is the virtual
table not the original table.
so, if we want to update the table we have to update that
outside the view or directly but not using view.
if we update through view its temporary means just in the
view only but will not reflect in the base table.
| Is This Answer Correct ? | 6 Yes | 18 No |
Post New Answer View All Answers
What happens if date-only values are provided as date and time literals?
How network traffic be reduced by using the stored procedure?
what is raid and what are different types of raid configurations? : Sql server database administration
what are the three command line utilities and what are their primary functions?
What are trace flags and mention a few common trace flags used with sql server?
What is dirty read?
What are the main differences between #temp tables and @table variables and which one is preferred?
What are the advantages of the mirroring?
Write the SQL query to drop, truncate and delete table.
Tell me about normalization in DBMS.
What is the difference between Clustered and Non-Clustered Index?
What is stored in the mssqlsystemresource database? : sql server database administration
What is format parameter in ssrs?
Can you get second highest salary from the table?
What happens if you delete a table that is used by a view?