Skip to content

Instantly share code, notes, and snippets.

@l2m2

l2m2/sqlserver-多表联合更新

Created April 25, 2020 06:36
Show Gist options
  • Save l2m2/3cdbf2b2b925f04e9e9f0977a17a8a12 to your computer and use it in GitHub Desktop.
Save l2m2/3cdbf2b2b925f04e9e9f0977a17a8a12 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sqlserver-多表联合更新
update utclabm_formula_control_info
set group_id = t2.group_id
from utclabm_formula_control_info t1
inner join ( select group_id, line_id from utclabm_station where status = 'active' ) t2
on t1.line_id = t2.line_id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment