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

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

3 Answers   IBM, L&T,

What is the role that is required for killing a process What is the role that is required for creating a linked server

1 Answers   CarrizalSoft Technologies, IBM,

if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

2 Answers  

how to replace double quotes by single quotes in sql server

2 Answers   CAC,

Can a table have 2 primary keys?

0 Answers  




How to create a simple table to test triggers in ms sql server?

0 Answers  

How to retrieve data from log files in SQL SERVER ?????

1 Answers  

Can we call future method from queueable?

0 Answers  

Can a database be shrunk to 0 bytes, if not, why?

0 Answers  

Explain what is row_number function?

0 Answers  

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories