修改语句

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;

posted @ 2015-01-26 13:14  apegu  阅读(283)  评论(0编辑  收藏  举报