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

What is a Join in SQL Server?

3 Answers  

How will you add a dimension to cube? : sql server analysis services, ssas

0 Answers  

Explain few examples of stored procedure over triggers?

0 Answers   ADITI,

Explain a checkpoint?

0 Answers  

What is difference between createstatement and preparedstatement?

0 Answers  

Can you leave a union at any time?

0 Answers  

Explain “@@rowcount” and “@@error” in sql server?

0 Answers  

Is the order of columns in the set clause important in ms sql server?

0 Answers  

What will happen if a column containing char type data is changed to the nchar data type?

0 Answers  

What is the command to change the recovery model?

0 Answers  

How to create an multi-statement table-valued function?

0 Answers  

What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,

For more SQL Server Interview Questions Click Here
Categories