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
- 1 Answers
- 3071 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Explain intellisense for query editing
Explain what are page splits? : SQL Server Architecture
How many types of keys are there?
how will add additional conditions in sql?
List the different normalization forms?
How to scale out a federation by Sql statement?
Explain steps of normalization?
What is a data source or ds? : sql server analysis services, ssas
How to add additional conditions in SQL?
Explain difference between control flow and data flow?
What is a trace frag? Where do we use it?
How to get a list all databases on the sql server?
What is the return type of executeupdate ()?
What is rs.exe utility?
How to populate a table in sql server?
