Answer Posted / abi

Types of Joins
1.Inner Join
2.Outer Join
-- Left Outer Join
-- Right Outer Join
-- Full Outer Join
3.Self Join
4.Cross Join
5.Equi-Join
6.Cross Apply Join
7.Outer Apply Join

What do you mean by acid?

1058

---

What is a covering index?

1043

---

What is difference between foreign key and unique key?

1049

---

What are scalar functions?

1051

---

What is tablesample?

1177

---

What are subqueries in sql server? Explain its properties.

1072

---

What is resultset concur_updatable?

1054

---

What is the fastest way to permanently delete a 1 million row table named customers?

1329

---

Why I am getting this error when renaming a database in ms sql server?

1109

---

List few advantages of stored procedure.

1026

---

What are commonly used odbc functions in php?

1059

---

What is 2nf normalization?

1089

---

How can I add Reporting Services reports to my application?

132

---

How can we solve concurrency problems?

1098

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

1021

---