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.

What is explicit mode in sql server?

0 Answers  

---

What is the command used to recompile the stored procedure at run time?

0 Answers  

---

* CREATE TABLE [dbo].[t_Colors]([ColorId] [int] NOT NULL,[ColorName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ColorDesc] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,[ColorIndex] [int] NULL) ON [PRIMARY] GO * insert into [t_Colors] values(101,'Red','',1) insert into [t_Colors] values(101,'Red1','',2) insert into [t_Colors] values(102,'Blue','',1) insert into [t_Colors] values(102,'Blue1','',2) insert into [t_Colors] values(102,'Blue2','',3) * In this table i need to delete DELETE FROM t_Colors WHERE ColorIndex=1 AND ColorId=102 After delete above condition i need to update the ColorIndex set to 1 for Blue1[ColorName] and 2 for Blue2[ColorName] select * from [t_Colors] Note:- how can i get updates the ColorIndex values after delete. for example we need to update Blue1 ColorIndex set to 1 and Blue2 ColorIndex set to 2

0 Answers  

---

select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?

7 Answers  

---

What are cursors? Name four types of cursors and when each one would be applied?

3 Answers   Adea Solutions,

---

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 Answers  

---

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

0 Answers  

---

How you provide security to cube? : sql server analysis services, ssas

0 Answers  

---

what is difference between nchar and char in Sql server ?

3 Answers  

---

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

0 Answers  

---

Explain what are sparse columns?

0 Answers  

---

What do you understand by triggers and mention the different types of it?

0 Answers  

---