Interested to Buy Any Domain ? << Click Here >> for more details...
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 does this statement do @@rowcount?
Find columns used in stored procedure?
What is the openxml statement in sql server?
Where is my database stored on the hard disk in ms sql server?
What stored by the tempdb ? : sql server database administration
What are the disadvantages of indexes?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is the difference between a primary key and a unique key? Are they the same?
Explain trigger and trigger types?
Write a SQL command to insert and update only a particular field?
what type of index will get created after executing the above statement? : Sql server database administration
What is the difference between varchar and varchar(max) datatypes?
What is the sql case statement used for? Explain with an example?
Can we call future method from trigger?
What is bulkcopy in sql?
