Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


* 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

Question Posted / siva

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

Post New Answer

More SQL Server Interview Questions

What is the difference between migration and upgradation in sql server?

0 Answers  

what stored procedure can you use to display the current processes? : Sql server administration

0 Answers  

What is the difference between locking and multi-versioning?

0 Answers  

When a primary key constraint is included in a table, what other constraints does this imply?

0 Answers  

Explain tablesample?

0 Answers  

What is sql server agent and what are the two modes of authentication in sql server?

0 Answers  

Without Using Cursors , How to Select the Selected row??

3 Answers   CarrizalSoft Technologies, Wipro,

How to Get the last identity value used

4 Answers  

What is application role in sql server database security? : sql server security

0 Answers  

What is the purpose of the model database?

0 Answers  

Differentiate between truncate vs delete in mssql?

0 Answers  

What is named calculation? : sql server analysis services, ssas

0 Answers  

For more SQL Server Interview Questions Click Here
Categories