select Col1,col2 into newtable

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

Question Posted / amit kumar

Answer Posted / amit kumar

Is This Answer Correct ?

0 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Why functions are used in sql server?

916

Do you know exporting and importing utility?

991

How to disable stored procedure sql server?

1546

Can a database be shrunk with users active?

1080

Define self join in sql server joins?

919

What is the use of toad or sqldbx.?

1117

What is auditing in sql server?

892

What is meant by dirty read?

960

Explain about merge replications?

988

What are different types of constraints?

888

Mention the different types of replication in sql server.

976

do you know how to configure db2 side of the application? : Sql server database administration

1003

Where can you add custom error messages to sql server?

1065

What are the new scripting capabilities of ssms? : sql server management studio

1014

What is the difference between upgrade and migration in sql server?

1045