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
- 3886 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
How to delete duplicate rows from table except one?
what is raid? : Sql server database administration
What is the difference between seek predicate and predicate?
Are connections to sql server encrypted?
What does ss stand for sexually?
Will sql server 2005 allow you to reduce the size of a column?
How many triggers are possible per table?
How to list all user defined functions in the current database?
How to specify the collation for a character data type in ms sql server?
How to receive output values from stored procedures?
Give a example to search fr a string in all stored procedure in sql server.
Can you explain what is indexed view? How to create it?
How to create new databases with "create database" statements?
What is a transact-sql statement?
How to loop through result set objects using odbc_fetch_row()?
