Answer Posted / b.kumar

--MS SQL SERVER

WE CAN DISPLAY RECORDS BY USING 9 JOINS

SELECT TBL1.COLUMN1,TBL2.COLUMN2,---------,TBL10.COLUMN10

FROM TBL1 INNER JOIN TBL2 ON TBL1.ID=TBL2.ID
INNER JOIN TBL3 ON TBL1.ID=TBL3.ID
----
----
----
INNER JOIN TBL10 ON TBL1.ID=TBL10.ID
----------------------------------------
--WE CAN ALSO DISPLAY THE RECORDS WITH OUT USE JOINS

SELECT TBL1.COLUMN1,TBL2.COLUMN2,---------,TBL10.COLUMN10
FROM TBL1,TBLE2,--------,TBL10
WHERE TBL1.ID=TBL2.ID OR TBL1.ID=TBL3.ID OR
----
----
----
TBL1.ID=TBL10.ID
--WE MUST USE WHERE CLAUSE OTHER WISE WE GET Cartesian product.

--------------------------------------------------

WE CAN'T JOIN DIFFERENT TABLES OF COLUMNS BY USING UNION

BECAUSE UNION COMBINES THE TWO OR MORE RESULT SETS
(IT MEANS ROWS)

DIFFERENCE BETWEEN JOIN & UNION

-- JOIN COMBINES TWO OR MORE THE COLUMNS
-- UNION COMBINES TWO OR MORE ROWS

what is bit datatype? : Sql server database administration

919

---

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

1046

---

What are triggers in ms sql server?

1163

---

What is normalization process?

1181

---

How do you make a trace?

1025

---

What is for xml in sql server?

1076

---

application server is slow what may be the problem

2225

---

How use inner join in sql server?

1134

---

How except clause is differs from not in clause?

955

---

where can you add custom error messages to sql server? : Sql server administration

1120

---

What’s the distinction between dropping a info and taking a info offline?

1038

---

What do you understand by intent locks?

1012

---

What is extent? Types of extents?

1195

---

How many triggers are possible per table?

1098

---

How to drop an existing schema in ms sql server?

1103

---