June 9, 2011

How to swap two column value in SQL Server

DECLARE @T INT
UPDATE <Table Name>
SET @T = <Field1>,<Field1> = <Field2>,<Field2>=@T

No comments:

Post a Comment