Why I am getting "the microsoft .net framework 2.0 in not installed" message?
No Answer is Posted For this Question
Be the First to Post Answer
Explain different types of collation sensitivity?
What is clr ddl trigger?
What is a file group?
Explain triggers?
* 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 order of B+tree?
Explain the architecture of SQL Server?
What is the difference between deallocate cursor and close cursor?
Does transparent data encryption provide encryption when transmitting data across the network?
diffrence between Cluster Index and non Cluster Index
what is a deadlock? : Sql server database administration
How to create user messages with print statements in ms sql server?