修改语句

update SysRoleAction set UpdateOn = sr.UpdateOn from SysRole as sr, SysRoleAction as sra where sr.RoleValue=sra.RoleId and RoleValue=2 and sr.Id=42;

原文地址:https://www.cnblogs.com/jiangqw/p/4250061.html