4 and 12 from Exam 28.06

--04. Delete
DELETE TravelCards
WHERE JourneyId IN (1,2,3)

DELETE Journeys
WHERE Id IN (1,2,3)

--12. Change Journey Purpose
CREATE PROCEDURE usp_ChangeJourneyPurpose(@JourneyId INT, @NewPurpose VARCHAR(11))
AS
BEGIN
    IF NOT EXISTS(SELECT Id FROM Journeys WHERE Id=@JourneyId)
    THROW 51000, 'The journey does not exist!', 1

    IF (SELECT Purpose FROM Journeys WHERE Id=@JourneyId)=@NewPurpose
    THROW 51001, 'You cannot change the purpose!', 1

    UPDATE Journeys
    SET Purpose=@NewPurpose
    WHERE Id=@JourneyId
END