Sorry for previous answer. DECLARE @temp AS varchar(50) UPDATE swapdata

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

Question Posted / ami tkumar

Answer Posted / ami tkumar

Sorry for previous answer.

DECLARE @temp AS varchar(50)
UPDATE swapdata SET @temp=value2,value2=value1,value1=@temp

Is This Answer Correct ?

5 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How to enable/disable indexes?

1068

What is exporting and importing utility?

1091

How do I know if localdb is running?

955

What is difference between index and primary key?

1100

What is the use of “join” in sql server?

1099

Can we linked SharePoint to a SQL database?

1031

Why do we backup Active Directory ?

1046

What is the difference between SQL notification and SQL invalidation?

1194

What is catalog views?

1071

what is memory-optimized nonclustered indexes

1018

What is normalization? What number of normalization shapes are there?

1109

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

971

List the different normalization forms?

985

Explain partitioned view?

1086

Equi join and non equi join is possible with sql server?

1025