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

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

Question Posted / mysql

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

Please Help Members By Posting Answers For Below Questions

Do you know what is sql injection?

1000

Why union all is faster than union?

913

what is a join and explain different types of joins? : Sql server database administration

960

Explain the dirty pages?

1008

What are the different types of join?

1173

What is the default server name for sql server?

1172

How do you delete a data source?

1011

Explain partitioned view?

1081

What is provisioning, billing and metering, and connection routing concepts in the service layer?

113

What are translations and its use? : sql server analysis services, ssas

1041

What authentication modes does sql server support?

1103

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

962

What are exact numeric data types in ms sql server?

1078

what are the important architecture components of SSRS?

140

Do you know what is replace and stuff function in sql server?

1021