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
- 3802 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How to achieve Paging of records in SQL SERVER?
0 Answers Petranics Solutions,
Explain trigger and trigger types?
Which is the main third-party tool used in sql server?
How do we get month name in SQL Server 2000, Oracle, MS Access?
What is replace and stuff function in sql server?
Does group by sort data?
What is auditing in sql server?
How to create a view with data from multiple tables?
What is an index. What are the types?
what is the difference between a primary key and a unique key? : Sql server database administration
can primery key be a non clustered index?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
