server/util/Migrator/DbScripts/2026-03-19_00_AddProviderAbilityViewAndReadByIdProc.sql

CREATE OR ALTER VIEW [dbo].[ProviderAbilityView]
AS
SELECT
    [Id],
    [UseEvents],
    [Enabled]
FROM
    [dbo].[Provider]
GO

CREATE OR ALTER PROCEDURE [dbo].[Provider_ReadAbilityById]
    @Id UNIQUEIDENTIFIER
AS
BEGIN
    SET NOCOUNT ON

    SELECT
        *
    FROM
        [dbo].[ProviderAbilityView]
    WHERE
        [Id] = @Id
END
GO