No Answer is Posted For this Question
Be the First to Post Answer
How to get the definition of a stored procedure back?
explain declarative management framework (dmf) in sql server 2008?
How many types of subqueries are there in sql server?
How to use subqueries with the in operators in ms sql server?
Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?
How to convert character strings into numeric values?
* 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
difference between truncate, delete aur drop?
What are SQL Jobs, please mention the use of it and how to create them.
what is the difference between openrowset and openquery?
How to rebuild the master database?