The Tech Pursuit
The Dev Shelf
Pages
Home
Interview Questions
About Me
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment