What is difference between drop truncate and delete?
No Answer is Posted For this Question
Be the First to Post Answer
What are subqueries in sql server?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
* 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
How to transfer a table from one schema to another?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What are tasks?
Tell me what is a linked server?
What is stored in the mssqlsystemresource database? : sql server database administration
Why does sql studio use a single registered database repository? : sql server management studio
How is sql used in sql server?
What is a covering index?