Sign Up Login


  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 log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

0 Answers  

What are the different types of replication you can set up in sql server?

0 Answers  

How to invoke a trigger on demand?

0 Answers  

What is xdr?

0 Answers  

What is the order in which the SQL query is executed? list them in order.

5 Answers   CarrizalSoft Technologies, CTS, Oracle,




Is it important for a database administrator to understand the operating system and file access?

0 Answers  

Which sql server table is used to hold the stored procedure script?

0 Answers  

What are “lost updates”?

0 Answers  

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

2 Answers   Genpact,

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

0 Answers  

If no size is defined while creating the database, what size will the database have?

0 Answers  

Explain system scalar functions?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories