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 are scheduled tasks in sql server?

1076

Explain steps of normalization?

995

What is sql server used for?

1041

What are commonly used mssql functions in php?

1073

What is join and name different type of joins?

1045

How to provide default values to stored procedure parameters?

1062

What is optimization and its types?

967

what are constraints? Explain different types of constraints? : Sql server database administration

978

How do you make a trace?

1016

What are indexes in sql?

1273

What is multi-statement table-value user-defined function?

987

Explain forward - only cursors?

1054

How to remove duplicate rows from table?

1242

What are the database objects? : SQL Server Architecture

1041

What are the database roles? : sql server security

1175