Tutorials
Resources
Forum
Communities
Interview
Jobs
Projects
Offshore Development
Silverlight Tutorials
|
Mentor
|
Code Converter
|
Articles
|
Code Factory
|
Computer Jokes
|
Members
|
Peer Appraisal
|
IT Companies
|
Bookmarks
|
Revenue Sharing
|
Prizes & Awards
My Profile
Sign In
Register
AdSense Revenue
Active Members
Today
Abhi
(58)
Appukuttan
(40)
divya
(36)
Last 7 Days
Appukuttan
(660)
Babu Akkandi
(465)
Tejinder Singh ...
(273)
more...
New Feature:
Community Sites
:
Create your own .NET community website and start earning from Google AdSense !
It's Free !
How to Update a table with update and case
Posted Date: 16 Jun 2008
Resource Type:
Code Snippets
Category:
SQL
Author:
Phani
Member Level:
Silver
Rating:
Points
: 10
"table1" has a column called city. The records with city='Delhi' are to be updated with city='Mumbai' and records with city='Mumbai' are to be updated with city='Delhi'. Write a single SQL statement to do this.
update table1
set name1 = case name1 when 'Delhi' then 'mumbai'
when 'mumbai' then 'delhi'
end
Responses
Author:
Kapil Dhawan
17 Jun 2008
Member Level:
Gold
Points
: 1
Hello
Nice piece of code
Thanks for sharing your knowledge with us.
I hope to see more good code from your side
Regards,
Kapil
Feedbacks
Popular Tags
What are tags ?
Search Tags
Sign In
(No tags found.)
Post Feedback
This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must
Sign In
to post a response.
Next Resource:
How to see whether the stored procedure is present or not?
Previous Resource:
Use of LIKE wildcard
Return to Discussion Resource Index
Post New Resource
Category:
SQL
Post resources and
earn money
!
Related Resources
Advantages of UDFs
working with SELECT
Regarding connection strings of Sql Server 2005 compact Edition
Converting Multiple Columns into single Row or Column
MYSQL Procedure with SQLTransactions and Exception Handling
dotNet Slackers
BizTalk Adaptors
Web Design
Contact Us
Privacy Policy
Terms Of Use