Answer Posted / mehtab ullah

Purpose of view

Views hide data complexity.
Views add security by restricting access to the columns of a
table.
Views simplify the complex queries for the user.
View is a way to isolate application from changes in
definitions of base tables.
View is derived from the perant table.
View do not occupy any space in the memory .

What are the types of subscriptions in SQL Server replication?

1104

---

How to create a trigger for insert only?

1084

---

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

1030

---

What is query and its types?

954

---

What are cursors in ms sql server?

1241

---

What is the difference between a "where" clause and a "having" clause?

1210

---

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1050

---

SQL Server Architecture ?

2520

---

how you can deploy an ssrs report?

185

---

What is named calculation? : sql server analysis services, ssas

1024

---

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

2085

---

How do I start sql server agent automatically?

1027

---

How can we check the sql server version?

1125

---

What is report snapshot in ssrs?

280

---

How many triggers are possible per table?

1140

---