DECLARE @RoleName VARCHAR(MAX)
DECLARE @AdminRolePermissions VARCHAR(MAX)

SET @AdminRolePermissions = 'Test1,Test2,Test3'
SET @RoleName = 'Admin'

INSERT INTO AbpPermissions
SELECT
t.Id AS TenantId,
p.Data AS Name,
(Select 1) AS IsGranted,
(SELECT getdate()) AS CreationTime,
NULL AS CreationUserId,
r.Id AS RoleId,
NULL AS UserId,
'RolePermissionSetting' AS Discriminator
FROM dbo.[Split](@AdminRolePermissions, ',') AS p
FULL JOIN AbpTenants t ON 0 = 0
INNER JOIN AbpRoles r
ON r.TenantId = t.Id
WHERE r.Name = @RoleName