Answer Posted / praveen mehta

There are 2 possible answers
1. No joins required

Ex:
SELECT Col1 As Col from Tab1
Union
SELECT Col2 As Col from Tab2
Union
SELECT Col1 As Col from Tab3
...

2. 9 Joins Required
Ex:
SELECT
t1.Col1,
t2.Col2,
....
FROM Tab1 t1
inner join Tab2 t2 on t1.Col1=t2.Col2
inner join Tab3 t3 on t1.Col1=t3.Col2
....

Explain different types of lock modes in sql server 2000?

940

---

What is exporting utility?

1032

---

Can select statements be used on views in ms sql server?

1073

---

How to create “dependant” parameter “make, model, year”

133

---

Can you explain different types of locks in sql server?

953

---

How do I setup a sql server database?

1082

---

What is query cost in sql server?

1001

---

What is coalesce in sql server?

1064

---

What is table value parameters (tvp)?

1109

---

Explain nested trigger in sql?

1088

---

How you can get a list of all the table constraints in a database? : Sql server administration

1035

---

What is clustered vs nonclustered index?

959

---

What is t-sql script to take database offline – take database online.

1093

---

Tell me about normalization in DBMS.

1003

---

Tell me what is difference between view and materialized view?

947

---