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
- 3210 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
What is the template in sql?
What is indexing and its types?
What is the importance of concurrency control?
What is acid db?
what are the critical issues you have resloved in your company
What is snapshot report?
what is the different types of backups available in sql server? : Sql server database administration
Which tcp/ip port does the sql server run on? How can it be changed?
What is the downside of using udf?
What do we have to check in database testing?
What is difference between unique and primary key?
Explain four layers of abstraction microsoft architectured?
How data can be copied from one table to another table?
What is the difference between functions and stored procedures?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
