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 will be the maximum number of indexes per table?

0 Answers  

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers  

What is transactional replication?

0 Answers  

Which data type can be used only on OUTPUT parameters of the stored proceduer?

2 Answers  

What is 1nf normalization form?

0 Answers  

What is the difference between indexing and hashing?

0 Answers  

The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

0 Answers  

What is page-level compression?

0 Answers  

What is the primary use of the model database?

0 Answers  

Differencr Between DELETE and TRUNCATE?

3 Answers   ADP,

Explain transaction server explicit transaction?

0 Answers  

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories