* 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
No Answer is Posted For this Question
Be the First to Post Answer
How to get the count of distinct records. Please give me the query?
Why use stored procedures in sql server?
How to swap the data of two columns in a table. both the columns containing varchar values.
CTE(common table expression)
Describe the functionalities that views support.
Explain timestamp datatype?
Explain the properties of a relational table?
What is sql service broker?
how insert selected column only ?
How to provide default values to function parameters?
What is the difference between set and select?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration