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.

What is the maximun sixes of .mdf in sql server 2005

1 Answers  

---

what is nonclustered index

0 Answers  

---

Explain sql delete command?

0 Answers  

---

how can i store resumes in database?

3 Answers   HCL,

---

Define inner join? Explain with an example?

0 Answers  

---

What is index fragmentation in ms sql server?

0 Answers  

---

Explain the concept of view and Types of views in SQL server?

0 Answers   HCL,

---

How can you hide the sql server instances?

0 Answers  

---

How do you persist objects, permissions in tempdb

1 Answers  

---

What are the diifferences between the ms sql server vs mysql?

0 Answers  

---

How to encrypt Strored Procedure in SQL SERVER?

0 Answers  

---

What do you mean by sql server 2005 express management tools?

0 Answers  

---