Why use update_statistics command in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
What is the order by used for?
Do you know sql server 2008 introduces automatic auditing?
How to create a trigger for insert only?
Can you explain some of the DTS problems?
What is a result set object returned by odbc_exec()?
If i am handling 150 servers then how to check the active jobs of all the servers?
How many levels of sp nesting are possible?
What are the difference between clustered and a non-clustered index?
* 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
Which table keeps the locking information?
What does the automatic recovery do?
What are pessimistic lock and optimistic lock?