Answer / sabareetha

If the view is created with single table. Updating a view
will affect the origival records in the table

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 .

Answer / sangita

No

Answer / anil

yes

Answer / soorai ganesh

No. Updating View will not affect the table records.

What is the name of the Database which IBM mainframe uses?

0 Answers   Wipro,

---

What is the difference between composite index and covering index?

0 Answers  

---

What is a with(nolock)?

0 Answers  

---

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 Answers  

---

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  

---

---

How do I connect to sql server database?

0 Answers  

---

What are the rules to use the rowguidcol property to define a globally unique identifier column?

0 Answers  

---

can we have a nested transaction? : Sql server database administration

0 Answers  

---

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

0 Answers  

---

please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.

1 Answers   TCS,

---

What is the dbcc command and why is it used?

0 Answers  

---

Explain temporary table vs table variable by using cursor alternative?

0 Answers  

---