Monday, 15 December 2008

SQL Copy data from one table to another using join

UPDATE @SampleTable
SET Name = t.Name
FROM @SampleTable s
JOIN Table1 t
on t.Id = s.Id

No comments:

Post a Comment