> ## Documentation Index
> Fetch the complete documentation index at: https://rajanand.org/llms.txt
> Use this file to discover all available pages before exploring further.

# How to swap column value in SQL?

## Question:

Write an update statement to swap the column values without using a temporary tables.

Before Update:

<Frame>
  ![image.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1649525307382/rEmMCQXk-.png)
</Frame>

After Update:

<Frame>
  ![image.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1649525352393/87VbHWHky.png)
</Frame>

## Answer:

```sql theme={"system"}
UPDATE dbo.STUDENT
SET first_name = last_name,
	last_name = first_name;

```

<Frame>
  ![swap column values in sql - rajanand.org.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1649533041366/hTCbN0BbG.png)
</Frame>