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

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,

What is the new security features added in sql server 2014? : sql server security

0 Answers  

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

0 Answers  

How data can be copied from one table to another table?

0 Answers  

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

0 Answers   MCN Solutions,




Do you know the isolation level that sql server support?

0 Answers  

How is sql used in sql server?

0 Answers  

What is named calculation? : sql server analysis services, ssas

0 Answers  

is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 Answers  

What are cursors?

8 Answers  

How to replace the Query Result 'Null Value' with a text ?

0 Answers   MCN Solutions,

What is difference between rownum and row_number?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories