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

Can we write trigger for view?

0 Answers  

please tell me the query to get details of the employee having the second largest salary

11 Answers   247Customer,

how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.

0 Answers  

How column data types are determined in a view?

0 Answers  

is it important for a database administrator to understand the operating system and file access? : Sql server administration

0 Answers  

What is the difference between functions and stored procedures?

0 Answers   Accenture,

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 Answers   Cognizant, HCL, Value Labs,

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

0 Answers  

What is difference between oltp and olap?

0 Answers  

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

0 Answers  

Explain what are partitioned views and distributed partitioned views?

0 Answers  

Does order by actually change the order of the data in the tables or does it just change the output?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories