Pages

Social Icons

Friday 28 December 2012

Swipe a column value in SQL-Server


Some time we need to update one column with another in the same table or we can say swipe a value. For this we can use simple update statement as follows

UPDATE temp t
SET t.testColimn1 = t.testColimn2, 
t.testColimn2 = t.testColimn1

Thx,
RS

No comments:

Post a Comment