How to swap the data of two columns in a table. both the
columns containing varchar values.
- 9 Answers
- 15904 Views
- I also Faced
- E-Mail Answers
Answer Posted / nilesh
UPdate temp
set col1=col2,
col2=col1
| Is This Answer Correct ? | 21 Yes | 15 No |
Post New Answer View All Answers
How you can find out if an index is useful to the optimizer?
What are the restrictions that views have to follow? : SQL Server Architecture
How important do you consider cursors or while loops for a transactional database?
How to integrate the ssrs reports in application?
Why main is user defined function?
How do I partition a table in sql server?
How to enter unicode character string literals in ms sql server?
What is check constraint in sql server?
How to bind a view to the schema of the underlying tables?
How many types of built in functions are there in sql server 2012?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
Explain transaction server auto commit?
How to convert numeric expression data types by assignment operations?
What is meant by Active-Passive and Active-Active clustering setup?
What are sub reports and how to create them?
