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.

How to filter records of table in SQL SERVER?

1062

---

How is sql used in sql server?

990

---

Is sql server implemented as a service or an application? : Sql server database administration

943

---

Write a program to fetch first 10 records from a file?

988

---

How to execute a stored procedure in ms sql server?

1136

---

What is a partition function in sql server?

1097

---

What are filegroups in sql server?

1047

---

What is report snapshot in ssrs?

264

---

What does the not null constraint do?

1062

---

Does sql server 2016 have ssms?

940

---

What do you understand by the analysis services in sql server?

930

---

Explain various data region available in ssrs with their use?

910

---

How can I tell if sql server is 32 or 64 bit?

937

---

How many cores do I need for sql server 2016?

875

---

How to set database to be single_user in ms sql server?

1010

---