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

what is the main function of a query parameter?

140

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

990

What is a domain constraint give an example?

1000

Who is the owner of a schema in ms sql server?

1005

What is the difference between cube operator and rollup operator? : SQL Server Architecture

1052

What are the different types of triggers in SQL SERVER?

1047

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

1015

What are the advantages of using third-party tools?

916

What is table level trigger?

948

can you implement data mining in SSRS?

137

What is sql profiler. What are the default templates with it? : sql server database administration

949

What is a DBMS, query, SQL?

992

What is an expensive query?

877

How many joins in sql server?

896

Tell me what do you understand by a view? What does the with check option clause for a view do?

955