常用SQL之：联表更新 

update a 
set a.UserRoleName=b.Name
from Users  a
inner join Role  b
on a.RoleId=b.Id

 

posted @ 2021-10-21 09:33  LoveMe7788  阅读(197)  评论(0)  编辑  收藏  举报