How do I swap column values in sql server 2008?

Update employee
Set attributeValue = attributeName,
    attributeName = attributeValue

update Employee set AttributeValue = AttributeName, AttributeName = AttributeValue

UPDATE employee
SET AttributeValue = AttributeName, 
    AttributeName = AttributeValue

However, unless both columns have the exact same definition, you risk losing information.