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
- 3752 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 candidate key with example?
Mention a few common trace flags used with sql server?
Characterize join and name diverse sorts of joins?
What is transact-sql language?
What stored by the master?
When cursors are useful?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
Explain different types of index?
What is sql server query analyzer?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
Explain the usage of floor function in sql server.
Do you know what are the ways available in sql server to execute sql statements?
How to filter records of table in SQL SERVER?
What do you mean by recursive stored procedure?
