* 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  

---

What is a transactions?

0 Answers  

---

What is the use of DBCC commands?

4 Answers   NA,

---

What is Left Outer Join?

2 Answers  

---

Does partitioning improve performance sql server?

0 Answers  

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

What do you mean by a dependent functionality in a build?

0 Answers   HCL,

---

Different types of keys in SQL?

0 Answers   Infosys,

---

can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  

---

syntax and example for bitmap index in sql???

1 Answers  

---

Do you know what is a with(nolock)?

0 Answers  

---

What is the language structure to add a record to a table?

0 Answers  

---