Whether the updations made to the views reflect the
original records in the table
Answer Posted / 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 |
Post New Answer View All Answers
Can we store videos inside the sql server table?
What is mscorsvw.exe - process - microsoft .net framework ngen?
What is the purpose of linked server configuration in sql server?
How many types of cursor type are there?
Why are sql functions used?
How many replicas are maintained for each SQL Azure database?
What is self join in sql server joins?
Explain differentiate between a having clause and a where clause?
What are the different types of backups avaialabe in sql server 2005?
What is difference between temp table and cte?
How to generate random numbers with the rand() function in ms sql server?
What are trace flags and mention a few common trace flags used with sql server?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
Do you know what is a linked server in sql server?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?