Move one column to another

Question

I have table

Employee 
{
EmpId,
FirstName,
LastName,
DeptId
}

Department
{
DeptId,
DeptName,
Specialization
}

Now I had added specialization column to Employee, so now the new Employee table is:

Employee 
{
EmpId,
FirstName,
LastName,
DeptId,
Specialization
}

Now I want update script to move specialization data from Department to Employee.

The question is not that clear. Do you ask for a query, an update-sql or a sql-script which changes the table columns? — Tim Schmelter, Nov 07 '14 at 13:53
possible duplicate of [UPDATE from SELECT using SQL Server](http://stackoverflow.com/questions/2334712/update-from-select-using-sql-server) — Tab Alleman, Nov 07 '14 at 13:53

score 1 · Accepted Answer · answered Nov 07 '14 at 13:52

1

You can use the update-join syntax:

UPDATE e
SET    e.Specialization = d.Specialization
FROM   Employee e
JOIN   Department d ON e.DeptId = d.DeptId

answered Nov 07 '14 at 13:52

Mureinik

297,002
52
306
350

score 0 · Answer 2 · answered Nov 07 '14 at 13:54

0

You can use simple nested queries;

Update Employee Ee
Set    Specialization = (SELECT Specialization
                         FROM   Department Dpt
                         Where  Dpt.DeptId = Ee.DeptId)

answered Nov 07 '14 at 13:54

Nadeem_MK

7,533
7
50
61

Move one column to another

2 Answers2