How to swap the data of two columns in a table. both the
columns containing varchar values.
- 9 Answers
- 15410 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 to defragment indexes with alter index ... Reorganize?
Explain datetime2 data type in sal server 2008?
What protocol does sql server use?
State the difference between local and global temporary tables?
How can we get count of the number of records in a table?
What is the difference between the 2 operating modes of database mirroring?
What is a rownum?
What is difference between foreign key and unique key?
How to provide values to user defined function parameters?
Can a table have 2 foreign keys?
what's the information that can be stored inside a bit column? : Sql server database administration
Define constraints and give an example of their use?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
How to drop an existing stored procedure in ms sql server?
How sql server executes a statement with nested subqueries?
