Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3670 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 importance of concurrency control?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What extended events?
How to use group functions in the select clause in ms sql server?
What is log shipping?
What is a data collection table?
What is use of except clause?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
How to connect ms access to sql servers through odbc?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What are the differences between substr and charindex in sql server.
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
What is the purpose of the tempdb database?
