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

Explain trigger and trigger types?

906

what is dbcc? : Sql server database administration

964

What will be the maximum number of index per table?

950

Define inner join in sql server joins?

986

How do I run sql server 2014?

936

How do I get Report Builder to generate a parameter that can be set by users viewing the report?

139

Explain what are page splits? : SQL Server Architecture

1002

What is the definition for sql server 2000?

1039

What is Replication?

988

What are the differences between sql server and mysql.

1021

How to fine-tune reports?

247

How to declare a cursor with "declare ... Cursor" in ms sql server?

975

What are the different editions available in sql server 2000?

992

What is the native system stored procedure to execute a command against all databases?

967

What is a cursor, index in sql?

1012