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
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
What method is used by the Command classes to execute SQL statements that return single values?
How to grant a permission in ms sql server using "grant execute" statements?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What are the pre-defined functions in the sql server?
A trigger can reference objects outside the current database? State true or false.
How to use old values to define new values in update statements in ms sql server?
Do you know what are various aggregate functions that are available?
What is the difference between a function and a trigger?
List out the differences between global and local temp tables in sql server?
What options are available to audit login activity? : sql server security
Explain cross join or cartesian product in sql?
How to create an identity column?
What is the log shipping?
What is the difference between count () and rowcount ()?