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

List the different types of collation sensitivities in sql server?

1043

What is the recursive stored procedure in sql server?

1018

What is clr ddl trigger?

957

How is table type constraint applied to a table?

974

What is a rownum?

968

what is raid and what are different types of raid configurations? : Sql server database administration

1032

List few advantages of stored procedure.

981

what is an index? : Sql server database administration

973

What is transaction server distributed transaction?

1052

Relational calculus is what type of language?

1031

What do you understand by replication in sql server? Mention the different types of replication in sql server.

940

What is the difference between deallocate cursor and close cursor?

1251

How to download and install microsoft .net framework version 2.0?

1133

What are the operating modes in which database mirroring runs?

1082

Can binary strings be used in arithmetical operations?

929