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

How many primary keys are possible in a table?

966

---

Why would you use sql agent?

1346

---

Can coalesce return null?

1070

---

what is the sql equivaent of the dataset relation object ?

2070

---

Why use “pivot” in sql server?

1182

---

what are the important architecture components of SSRS?

146

---

How many full-text indexes can a table have?

1026

---

What is a matrix in ssrs?

158

---

What is identity?

1083

---

Tell me what is the significance of null value and why should we avoid permitting null values?

1044

---

Define tempdb database?

1043

---

How dts is used to extract, transform and consolidate data?

1116

---

Is foreign key a primary key?

1179

---

How do you delete a trigger?

1035

---

How to automatically create a log when an exception is being received into SQL Server?

1361

---