Tag: statement
-
Single T-SQL query to swapping the values of two columns without using temporary column
How to swap the values of two columns of a table ? Let me explain the scenario with an example – Let’s create a table named “Employees” with columns “First_Name” and “Last_Name”. Then populate the table with some fictitious data. Then view the results once and then interchange the values in…