1. příklad - Volání

-- SLOUŽÍ PRO ZMĚNU PARAMETRU KTERÝ OVLIVNÍ VÝSLEDEK FUNKCE
-- confirm = 1,4,7 -> true
-- confirm = (0,2,3,5,6,8...) -> false
--update Reservation set confirm = 4 where idUser = 1 and seatnumber = 2;

-- VÝPISY SELECTŮ, KTERÉ KRMÍ KURZORY
select reservation.confirm from [user]
                join Reservation on [User].idUser = Reservation.idUser
                join TrainRide on Reservation.idTrainRide = TrainRide.idTrainRide
                join TrainCrew on TrainRide.idTrain = TrainCrew.idTrainRide
                join Staff on TrainCrew.idStaff = Staff.idStaff
                where [User].idUser = 1 and Reservation.idTrainRide = 1;

select distinct(staff.idstaff) from [user]
                join Reservation on [User].idUser = Reservation.idUser
                join TrainRide on Reservation.idTrainRide = TrainRide.idTrainRide
                join TrainCrew on TrainRide.idTrain = TrainCrew.idTrainRide
                join Staff on TrainCrew.idStaff = Staff.idStaff
                where [User].idUser = 1 and Reservation.idTrainRide = 1;

print urb0061.CheckStaff(1,1);