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 you can get the list of largest tables in a database? : Sql server administration

1 Answers  

How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.

8 Answers   Intelenet,

How you can get the list of largest tables in a database?

1 Answers  

How to write a query with a right outer join in ms sql server?

1 Answers  

what is blocking? : Sql server database administration

1 Answers  

How many types of local tables are there in sql server?

1 Answers  

What is a derived table?

1 Answers  

How to define output parameters in stored procedures?

1 Answers  

Do you have any idea about the tcl commands?

1 Answers  

How do I find information about the install locations for the various instances running on a computer?

1 Answers  

What is a trigger in sql server?

1 Answers  

What do you understand by a view? What does the with check option clause for a view do?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories