How to swap the data of two columns in a table. both the
columns containing varchar values.

Answer Posted / mysql

sorry guys, all ur answers are not working properly.
Try to answer in one sql statement.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Name some of the open source software that you can use in alternative to SSR?

105


What is the command to change the recovery model?

565


When would you use sql joins?

524


In which tcp/ip port does sql server run? Can it be changed?

540


Why we use trigger in sql server with example?

509






What is resource db in sql server?

591


Where in ms sql server is ’100’ equal to ‘0’?

594


What are the purpose of Normalisation?

636


How to create median function?

118


What are the types of normalization?

547


How can I tell if sql server is 32 or 64 bit?

494


Explain about sql server login?

587


What is code near application topology?

197


what happens on checkpoint? : Sql server database administration

503


Explain aggregate functions?

552