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.

Explain various data region available in ssrs with their use?

0 Answers  

---

What is star, snowflake and star flake schema? : sql server analysis services, ssas

0 Answers  

---

What are the dmvs?

0 Answers  

---

How to generate create table script on an existing table in ms sql server?

0 Answers  

---

What is the use of toad or sqldbx.?

0 Answers   MCN Solutions,

---

---

How to use column default values in insert statements in ms sql server?

0 Answers  

---

What is primary key and example?

0 Answers  

---

What is a partitioned view?

0 Answers  

---

What are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

What is inner join in sql server joins?

0 Answers  

---

How do use Having,Group by,Group function in SQL?

0 Answers  

---

How to create a testing table with test data in ms sql server?

0 Answers  

---