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 to a statement batch if there is a compilation error?
When would you prefer to have a minimum number of indexes?
How to drop an existing user defined function in ms sql server?
What are the methods used to protect against sql injection attack?
What is the difference between SQL notification and SQL invalidation?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
What are the components of dbms?
What do you understand by user-defined function in the sql server?
what is datawarehouse?
Explain the types of indexes.
Explain view in sql server?
If user is owning any SQL Objects, can we drop that user
What are differences in between sql server 2012 and sql server 2016?
What is meant by indexing?
What is rs.exe utility?