insert into t_RolePermission( [f_intRoleId] ,[f_intPermissionId] ,[f_strNote] ) select 109 as roleId , f_intPermissionId as permissionId , null as note from t_Permission where f_intPermissionId in ( 2,4,5,8 ) delete t_RolePermission where f_intRoleId = 109