Answer Posted / g.ramesh

We have 3 Types of Outer Joins.
1.Left Outer Join
2.Right Outer Join
3.Full Outer Join

What are the different types of backups avaialabe in sql server 2005?

1002

---

How to use “drop” keyword in sql server and give an example?

1113

---

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1011

---

What is user-defined functions? What are the types of user-defined functions that can be created?

1019

---

What is an execution plan? How would you view the execution plan?

1052

---

What is an indice?

1017

---

Why should one not prefix user stored procedures with ‘sp_’?

1023

---

What is a partitioned view?

975

---

How to write a query with an inner join in ms sql server?

1023

---

What stored by the tempdb ? : sql server database administration

1030

---

Explain hostprotectionattribute in sql server 2005?

994

---

What is transaction server implicit?

987

---

Can I run multiple instances of sql server 2000 at the same time on one computer?

1059

---

How do you trace the traffic hitting a sql server?

1122

---

How do you open a cluster administrator?

1035

---