CREATE PROCEDURE `spGetNotification_Template` ( ) BEGIN SELECT `Id` , `Title` , `ifnull` ( `Remark` , ? ) AS `Remark` , `Template` , `ifnull` ( `MailSuject` , ? ) AS `MailSuject` , `ifnull` ( `SMSTemplateId` , ? ) AS `SMSTemplateId` FROM `teventmaster` ; END 