update tab1 set name=name1,name1=name

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

Question Posted / m s aptil

Answer Posted / m s aptil

Is This Answer Correct ?

2 Yes

9 No

Please Help Members By Posting Answers For Below Questions

1 01 101 01010

2100

What is the name of reporting services config file and what’s it’s used for?

153

What are the fixed server level roles? : sql server security

1223

How can I create a report based on a query? : sql server management studio

1063

What is the difference between left and right outer join?

1115

How column data types are determined in a view?

1007

How would you use user_constraints table in DB?

1060

How to connect php with different port numbers?

1147

How to insert data into an existing table?

1029

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1202

Which rendering formats are affected by the pagesize properties?

151

How do I create a trace in sql server?

1091

Other than truncate statement, which other command can by-pass the trigger on the tables?

1189

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

1054

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

1027