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
- 3788 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 are rest-style architecture's?
What is store procedure? How do they work? When do you use?
What is right outer join in sql server joins?
What is the difference between Stored Procedures and triggers?
Explain some stored procedure creating best practices or guidelines?
How to rebuild master databse?
What is the significance of master, tempdb and model databases?
What is sql stored procedure?
What is policy based management (pbm)? : sql server database administration
What is normalization and denormalization in sql server?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
Is sql server free?
Explain a differential backup?
What do you mean by table and field in sql?
What are differences in between sql server 2012 and sql server 2016?
