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.

What is the use of custom fields in report?

945

---

How to delete an existing database user?

967

---

Can you name some of the dml commands in sql?

960

---

How to select an exiting database using mssql_select_db()?

907

---

What are out-of-range errors with date and time literals?

965

---

Explain left outer join and right outer join?

967

---

How does the report manager work in SSRS?

142

---

What is relationship? What number of sorts of relationship are there?

1062

---

What are unicode character string data types in ms sql server?

1139

---

What are triggers? How do you invoke a trigger on demand?

1240

---

What command is used to create a database in the sql server and how?

1111

---

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

975

---

How to link tables in sql server?

889

---

Explain the properties of subqueries in sql server?

1016

---

What is msdb database? : SQL Server Architecture

1057

---