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 add code to the existing article (using improve article)?

0 Answers  

what is the difference between Delete and Truncate

4 Answers   CarrizalSoft Technologies, Geo Research Centre,

Which joins are sql server default?

0 Answers  

Explain different types of collation sensitivity?

0 Answers  

What are various ways to enhance the ssrs report?

0 Answers  




How do I install sql server?

0 Answers  

What are recommended options to be used while using db mirroring? : sql server database administration

0 Answers  

How can i change the column name.

13 Answers   HCL, Yardi Software,

Explain the basic concepts of SQL server architecture?

2 Answers   College School Exams Tests,

How to make remote connection in database?

0 Answers  

Explain following error properties?

0 Answers  

What do you think of this implementation? Can this be implemented better?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories