C# Tutorials and offshore development in India
    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



Active Members
TodayLast 7 Days more...
New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !



Posted By: Ashish Kumar Chaurasia       Member Level: Bronze       Posted Date: 05 Sep 2006       Category: SQL Server

Swapping in SQl Server

how swap column two column data in sql server through query?
for example: there are two fields FirstName and SecondName having large number of data
user enters data secondname in first and vice versa? How you swap these column data through query)
Select Answer:

Update Tablename set FirstName=Secondname and Secondname=FirstName
Use view fro that
Using fuction





      
Your Test Score: 0 / 0



Next Question: The stored procedure that is used to see Existing Indexes
Previous Question: Retrieve Top 100 Rows from a Table
Related Questions:
  • What does the CHECKSUM function do -


  • What will be the result of SELECT STR(6365, 3) Statement


  • With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?


  • A SQL command that is used to reduce the access time is


  • Which of the following types of replication scenarios are supported by the SQL Server?


    		•

    Categories

    ASP.NET C# VB.NET 
    .NET Framework SQL Server Other 

    Submit Interview/Test Questions with Answers and make money from adsense revenue sharing program

    Want to prepare for an interview? Try our aptitude tests and standard interview questions first.

    dotNet Slackers   BizTalk Adaptors    Web Design

    Contact Us    Privacy Policy    Terms Of Use