Answer / guest

Join actually puts data from two or more tables into a
single result set.

Answer / simran_8185@rediff.com

joins is one of the facility provided to retrieve the data
from one or more than one tables simultaneously bt there
should be data intergrity among those tables.

Answer / radhakrishnan

Join:

we are develop the table based on normalization
concept.data stored different table based on constraint.
when we required data from multiple table we need to use
Join clause.

we can use one or more than table in join caluse.

Explain how to use linked server?

0 Answers  

---

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

0 Answers  

---

What happens if we shrink log file in sql server?

0 Answers  

---

What are the differences between stored procedure and functions in SQL Server 2000?

25 Answers   College School Exams Tests, HCL, Infosys, TCS,

---

How do I make a resultset scrollable?

0 Answers  

---

What is difference between inner join and full join?

0 Answers  

---

Explain syntax for viewing trigger?

0 Answers  

---

What are the advantages of partitioning?

0 Answers  

---

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.

6 Answers  

---

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

8 Answers  

---

What is sql server management studio? : sql server management studio

0 Answers  

---

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 Answers   Microsoft, TCS, Techastrum,

---