CREATE PROCEDURE [dbo].[InsertBook]
    @bookName VARCHAR(50)
AS
    INSERT INTO [dbo].[Book] (bookName)
    VALUES (@bookName)

CREATE PROCEDURE [dbo].[verifyBook]
    IF (@bookName = 'A')
    BEGIN
        EXEC [dbo].[InsertBook] @bookName = 'A'
        SELECT 1
    END
    ELSE IF (@bookName = 'B')
    BEGIN
        SELECT 0
    END

CREATE PROCEDURE [dbo].[selectBook]
    SELECT
        id, name,
        CASE
           WHEN [dbo].[verifyBook] @bookName =  1
              THEN TRUE
              ELSE FALSE
        END AS Status
       FROM Books