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
- 3344 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
How to use go command in "sqlcmd"?
Is sql server implemented as a service or an application? : Sql server database administration
What is ms sql server reporting services?
What is extended stored procedures?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
how will add additional conditions in sql?
Is sql server is free?
What is the difference between coalesce() & isnull()?
how many triggers you can have on a table? : Sql server database administration
What is meant by Active-Passive and Active-Active clustering setup?
System requirements for sql server 2005 express edition?
Explain an automatic checkpoint
Can You Use Data Mining Models In Ssrs?
What is in place upgrade in sql server?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
