22,301
社区成员




if not exists(select 1 from tb where ugid = ... and uid = ...)
insert into...
begin tran
insert into _en_usergroupmember select (select g.ugid from _en_usergroup g where groupname='SA-supplier') ,u.uid,null
from _en_user u where u.loginid in
('AFung','AsCh','TL','BLaw','BnP','Eluen','IM','IsC','KammyF','MaCh','MH','StL','TL','TW','VH')
and u.uid not in(select uid from _en_usergroupmember)
Commit