List the types of recovery model available in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
Can you explain what are commit and rollback in sql?
* 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
Advantages and Disadvantages of Cursor?
15 Answers Polytechnic, TCS, Zenith,
Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....
Can the query output be sorted by multiple columns in ms sql server?
What are commit and rollback in sql?
Can we call a function that has out parameter in select statement
Write a sql query to display the current date?
Can two tables share a primary key?
How to delete database objects with "drop" statements in ms sql server?
How many types of functions are there in sql server?
What are the types of dml?