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.

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

0 Answers  

---

What is the default isolation level of the sql server database?

1 Answers   Ness Technologies,

---

What types of integrity are enforced by a foreign-key constraint

1 Answers  

---

What are sub-queries? Give example? In which case sub-queries are not feasible?

4 Answers   Infosys,

---

What are orphan records?

0 Answers  

---

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

0 Answers  

---

How to stop a loop early with break statements in ms sql server?

0 Answers  

---

Explain about link server in sql server?

0 Answers  

---

what is a transaction and what are acid properties? : Sql server database administration

0 Answers  

---

Explain the properties of subqueries in sql server?

0 Answers  

---

What is raid? : SQL Server Architecture

0 Answers  

---

What is dbcc command in sql server?

0 Answers  

---