explain different types of cursors? : Sql server database administration


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What happens if null values are involved in string operations?

0 Answers  


* 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

0 Answers  


What is msdb database? : SQL Server Architecture

0 Answers  


how to delete duplicate rows from table in sql server

12 Answers   HCL, UHG,


what does the automatic recovery do? : Sql server administration

0 Answers  


What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

7 Answers   Microsoft,


Can I save my report as html, excel or word? : sql server management studio

0 Answers  


How to test a dml trigger in ms sql server?

0 Answers  


Where can you find the error log information? : sql server database administration

0 Answers  


Give the query of getting last two records from the table in SQL SERVER?

0 Answers   Petranics Solutions,


what's new in sql server 2016?

0 Answers  


What is the difference between functions and scalar functions?

0 Answers   EXL,


Categories