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 exporting utility?

0 Answers  

---

Different types of keys in SQL?

0 Answers   Infosys,

---

Explain the different types of joins?

0 Answers  

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

0 Answers  

---

Why do we use sql limitations? Which constraints can we use while making a database in sql?

0 Answers  

---

Why we use trigger in sql server with example?

0 Answers  

---

Creating Tables Using SELECT

1 Answers  

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 Answers  

---

how we use window authentication connection with sql server.?

0 Answers   MCN Solutions,

---

What Is Rdbms?

0 Answers   Accenture,

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

0 Answers  

---