从数组中批量插入数据

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