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

How do I trace a query in sql server?

952

How to create a simple user defined function in ms sql server?

1021

what is a mixed extent? : Sql server administration

1104

Explain try...catch with sql server?

1021

What is a trigger and types of a trigger?

983

Scalability, Availability, Integration with internet, etc.)?

2878

What are user-defined functions (udfs) in sql server?

989

Does any body please help me what question's have asked for SSRS in the interview?

2148

What is an expression in ms sql server?

1075

What is meant by indexing files?

1042

Tell me what is sql profiler?

1029

You want to implement the many-to-many relationship while designing tables. How would you do it?

998

What are ddl (data definition language) statements for tables in ms sql server?

1104

How can a database be repaired?

988

What are difference between Cluster index and Non-Cluster index?

1079