Answer / ashok

1.If we create a table it will save in database but a view is a virtual image there is no physical existance.
2. We can use order by clause in tables but views does not support order by clause.
3.In a view we can specify only a select statement inside a view but in tables we use all dml,ddl statements.
4.If we updating a base table using view which contains joins may not update correctly,but in tables we can update using joins.

How to write a script for upate the data in prod , i have 50000 row are there

2 Answers   TCS,

---

How to insert and update data into a table with "insert" and "update" statements?

0 Answers  

---

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

0 Answers   IBM,

---

What are ddl (data definition language) statements for tables in ms sql server?

0 Answers  

---

What are the steps to take to improve performance of a poor performing query? : sql server database administration

0 Answers  

---

What is wide table?

0 Answers  

---

How do I create a trace in sql server?

0 Answers  

---

Explain Different types of Projects?

1 Answers  

---

How do I find the sql server database version?

0 Answers  

---

How to make a remote connection in a database?

0 Answers  

---

What is change data capture (cdc) in sql server 2008?

0 Answers  

---

What are the two virtual tables SQL Server maintains for triggers?

3 Answers  

---