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

Explain some stored procedure creating best practices or guidelines?

0 Answers  

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

Write a SQL query to make a column as unique?

0 Answers   Cap Gemini,

What guidelines should be followed to help minimize deadlocks?

0 Answers  

Can we delete data from a view?

0 Answers  

What is table-valued sub query?

0 Answers  

What is sql server replication? : sql server replication

0 Answers  

Can you explain the role of each service?

1 Answers  

How can you check the version of sql server?

0 Answers  

What are the two virtual tables SQL Server maintains for triggers?

3 Answers  

What are the main control-of-flow T-SQL constructs?

1 Answers  

How to use subqueries with the in operators in ms sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories