日期:2014-05-17 浏览次数:20727 次
delete from [UserGroupRole] where [GroupID]=9
insert into [UserGroupRole]([GroupID],[RoleID])
values(select u.id as [GroupID] ,r.id as [RoleID] from [usergroup]
as u ,[role] as r where u.id=9 and r.id in(30,31))
select * from [usergrouprole]
delete from [UserGroupRole] where [GroupID]=9
insert into [UserGroupRole]([GroupID],[RoleID])
select u.id as [GroupID], r.id as [RoleID]
from [usergroup] as u, [role] as r
where u.id=9 and r.id in(30,31)
select * from [usergrouprole]