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

Hi Friends,

I have a table in which there are thousands of records and
in city field there is NULL value for all records now i want
to change that null value with distinct values in each
record say delhi, bihar, agra, jaipur etc, what will be the
query for that?????

its not possible to update thousands of records one by one.
is there any alternative ...?

Plz help ... its urgent

Thanx in advance

Question Posted / ak


Hi Friends, I have a table in which there are thousands of records and in city field there is NU..

Answer / kiran kumar

it is not possible.since you have to provide 1000(if table
have 1000 records) city Name based on certain condition.So
there is no alternative.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How to verify the port number of the sql server?

0 Answers  

What is the partitioning method?

0 Answers  

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

0 Answers  

How to download and install microsoft sql server management studio express?

0 Answers  

What is the diff between Dynamic queries and static queries

1 Answers   CGG, ICS Integrated Computer Solutions,

which table keeps the locking information? : Sql server administration

0 Answers  

Introduction of rollup clause using sum and group by clause?

0 Answers  

Which sql server is best?

0 Answers  

How to add a new dsn with the odbc driver for sql server?

0 Answers  

What is the use of toad or sqldbx.?

0 Answers   MCN Solutions,

What is "scheduled jobs" or "scheduled tasks"?

0 Answers  

explain different types of jions with examples briefly?

2 Answers   Accenture, Excellence, Zensar,

For more SQL Server Interview Questions Click Here
Categories