I want to update two tables in one go. How do I do that in SQL Server 2005?

UPDATE 
  Table1, 
  Table2
SET 
  Table1.LastName="DR. XXXXXX", 
  Table2.WAprrs="start,stop"
FROM 
  Table1 T1, 
  Table2 T2
WHERE 
  T1.id = T2.id
AND 
  T1.id = '010008'

10 Answers
10

Leave a Reply

Your email address will not be published. Required fields are marked *