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

What is meant by Active-Passive and Active-Active clustering setup?

1067

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

161

Which Model uses the SET concept

933

Where can you add custom error messages to sql server?

1053

Explain features and concepts of analysis services?

930

How to convert binary strings into integers in ms sql server?

961

Determine when to use stored procedure to complete sql server tasks?

986

What is the difference between a check constraint and a rule?

1131

How many types of functions are there in sql server?

875

How to set database to be single_user in ms sql server?

967

What is attribute hierarchy? : sql server analysis services, ssas

961

What is TDS(Tabular Data Stream) Gateway?

121

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

936

What are drilldown reports?

140

Does a server store data?

864