Where is trigger in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
What is pivot and unpivot?
What happens if you insert a duplicate key for the primary key column in ms sql server?
What is the difference between count and distinct count?
What are the basic functions for master, msdb, model, tempdb databases?
How to create view in stored procedure sql server?
To which devices can a backup be created and where should these devices be located? : sql server management studio
What are the types of joins in sql?
What is an execution plan? When would you use it? How would you view the execution plan?
The Difference between 'Count' and 'Count(*)'
If we delete pack Spec what will be the status of pack Body ?
* 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
What is the sql case statement used for? Explain with an example?