Answer / s.chithiravelu

Join can be defined as an operation that includes the
retrieval of data from more than one table at a time.

Various Types of Joins:

Inner Joins
Outer Joins
Cross Joins
Equi Joins
Natural Joins
Self Joins

Answer / hari

Joins are reterving the data from the multiple tables
Inner Join
Outer Join-left outer join
-----------right outer Join
-----------Full outer Join
Cross Join

Explain what is dbcc?

0 Answers  

---

What is policy management?

0 Answers  

---

Explain what are the restrictions that views have to follow? : SQL Server Architecture

0 Answers  

---

What is deadlock and how to avoid the deadlocks.

3 Answers   TCS, Wipro,

---

What is the cartesian product of the table?

0 Answers  

---

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  

---

Determine how to use the inserted and deleted pseudo tables?

0 Answers  

---

Write an SQL query to obtain the 2nd highest salary.

0 Answers   Akamai Technologies,

---

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

0 Answers  

---

Which trace flags are enabled in sql server?

0 Answers  

---

What is a document index?

0 Answers  

---

Explain what is the difference between a local and a global temporary table?

0 Answers  

---