Answer / g.ramesh

Inner Join is default type of join.
It produce result set, which contain's only matched rows.

Answer / prasanna

Inner joins use a comparison operator(like = or <>)to match
rows from two tables based on the values in common columns
from each table.It is a default type of join.
These includes Equi Joins and Natural Joins.

What is sql collation?

0 Answers  

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

0 Answers  

---

Why is replication required on the sql server?

0 Answers  

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

0 Answers  

---

Tell me what is normalization? Explain different forms of normalization?

0 Answers  

---

What is the openxml statement in sql server?

0 Answers  

---

Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 Answers  

---

What is the datatype of rowid?

0 Answers  

---

What is difference between Triggers and store procedure?

2 Answers  

---

Explain about nested stored procedure?

0 Answers  

---

In clustered and non clustered indexes which one is faster while executing a query ?

1 Answers  

---

Difference between Cluster and Non-cluster index?

32 Answers   Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,

---