How to find the source of a table in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.
explain databases and sql server databases architecture? : Sql server database administration
How do you test your database? : sql server database administration
What is table-valued sub query?
What is the maximum rows in sql server table?
How can you append an identity column to a temporary table?
What is the difference between for xml raw and for xml auto?
What is mscorsvw.exe - process - microsoft .net framework ngen?
* 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
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How to write query to Delete the records in child table and corresponding records in parent table
How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.