Whether the updations made to the views reflect the
original records in the table
Answers were Sorted based on User's Feedback
Answer / sabareetha
If the view is created with single table. Updating a view
will affect the origival records in the table
Is This Answer Correct ? | 12 Yes | 2 No |
Answer / ravi sharma
in the case if same table (all column) are make a view then
updations reflect the original record in the table.
but mostly make a view to security purpose the , uniques
are constaint column are not use,
then not be reflect .
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / soorai ganesh
No. Updating View will not affect the table records.
Is This Answer Correct ? | 9 Yes | 13 No |
What are the new features in SQL Server 2005?
How do I find the query plan in sql server?
What is the difference between deallocate cursor and close cursor?
Can select statements be used on views in ms sql server?
What do you mean by sql server agent?
please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on
How would you add a section to a table?
In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;
What is database isolation in sql server? : sql server database administration
What is Sqlpaging in SqlServer 2005 ?
Do you know what are the properties of the relational tables?
Why I can not enter 0.001 second in date and time literals in ms sql server?