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
....

How to create a simple user defined function in ms sql server?

969

---

what is difference between NULL and ISNULL in SQL Server 2008?

965

---

What should be the fill factor for indexes created on tables? : sql server database administration

1099

---

What are pessimistic lock and optimistic lock?

997

---

What are the triggers in sql?

1018

---

What is SQL Azure Data sync?

119

---

what is an index? : Sql server database administration

931

---

What is create command?

927

---

List out different types of normalizations in sql server and explain each of them?

886

---

What do you mean by an execution plan?

1051

---

Where actually sql azure database is hosted?

161

---

What do you mean by authentication modes in sql server?

1028

---

What are the dis_advantages of stored procedures, triggers, indexes?

2170

---

Explain what is “asynchronous” communication in sql server service broker?

868

---

How to list all dsn entries on your local machine using odbc_data_source()?

978

---