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

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

0 Answers   HCL,

explain different levels of normalization? : Sql server database administration

0 Answers  

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

0 Answers  

what is web server?

3 Answers   Satyam,

what is sql injection in sql server?

2 Answers   TATA,

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

0 Answers  

what is Archive old data?

1 Answers  

How to create a testing table with test data in ms sql server?

0 Answers  

please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person

10 Answers  

What is transact-sql language?

0 Answers  

Can we create nonclustered index in a table without creating a clustered index

1 Answers  

how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.

6 Answers   IBM,

For more SQL Server Interview Questions Click Here
Categories