Збережені процедури
CREATE VIEW SystemSessions ASCREATE PROCEDURE `SessionsByType` (IN sType INT)
BEGIN
IF
sType < 0 OR sType>4 THEN
SELECT 'Тип указан не верно';
ELSE
SELECT s.SessionID AS "#", u.Login AS "Пользователь", r.`RoleName` AS "Роль", s.ComputerID AS "Комп.#", sst.SessTypeName AS "Тип сеанса", s.StartTime AS "Начало сеанса", s.EndTime AS "Окончание сеанса"
FROM sessions s
INNER JOIN users u USING (userID)
INNER JOIN roles r USING (RoleID)
INNER JOIN sessiontype sst USING (SessTypeId)
WHERE sst.`SessTypeID`=sType
ORDER by SessionID;
END IF;
END;
sType = 3