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

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

1000

What should be the fill factor for indexes created on tables? : sql server database administration

1139

What is molap and its advantage? : sql server analysis services, ssas

986

List few advantages of stored procedure.

981

Explain can SSRS reports Cache results?

158

What is the difference between cube operator and rollup operator? : SQL Server Architecture

1125

How to create a scrollable cursor with the scroll option?

999

How you would rewrite the sql query to return the customerid sorted numerically?

1001

Explain boyce and codd normal form(bcnf)?

958

What is meant by indexing files?

1043

Can you index views?

895

What are the different types of sub-queries?

1044

What is model database? : SQL Server Architecture

1133

What is the order by used for?

1024

What purpose does the model database server?

1102