Skip to content

Instantly share code, notes, and snippets.

@bartubozkurt

bartubozkurt/update_2.sql

Created June 13, 2021 08:23
Show Gist options
  • Save bartubozkurt/01c174e4064bb900627e987dd1250df5 to your computer and use it in GitHub Desktop.
Save bartubozkurt/01c174e4064bb900627e987dd1250df5 to your computer and use it in GitHub Desktop.
Download ZIP
UPDATE statement when updating one table with data from another table in SQL Server
Raw
update_2.sql
UPDATE table1
SET column1 = (SELECT expression1
FROM table2
WHERE conditions)
[WHERE conditions];
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment