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
- 3753 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 |
What is data source in connection string?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
what is bit datatype? : Sql server database administration
What is the purpose of the master database?
List out the difference between union and union all in sql server?
How many types of database relationship in sql server?
What happens if you are trying to access a schema not owned by you?
Explain syntax for viewing, dropping and disabling triggers?
What is a trigger? Why we need it?
What is the cartesian product of the table?
Explain relational data?
explain what is raid and what are different types of raid configurations? : Sql server database administration
-
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)
