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
How to use clusters?
How to return the top 5 rows from a select query in ms sql server?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
Explain tables in SQL Azure?
how can u get last observation in an unknown dataset ?
What is the Main Difference between ACCESS and SQL SERVER?
How can you control the amount of free space in your index pages?
How to truncate the log in sql server 2012? : sql server database administration
How raid can influence database performance?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
What does indexation mean?
Explain what are the authentication modes in sql server?
What is a raid and what are different types of raid configurations?
Write an sql query to find first weekday of the month?
What are the different acid properties?