All pastes #165955 Raw Edit

Miscellany

public text v1 · immutable
·published 2006-09-10 11:37 UTC
rendered paste body
DELIMITER $$

DROP PROCEDURE IF EXISTS `trancecendant`.`sp_GetEventFiles` $$
CREATE PROCEDURE `trancecendant`.`sp_GetEventFiles` (IN intEventId INTEGER)
BEGIN
  SELECT * FROM tblEventFiles WHERE intEventIdFk = intEventId
END $$

DELIMITER ;


/* Error Message */

Script line: 1	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER $$

DROP PROCEDURE IF EXISTS `trancecendant`.`sp_GetEventFiles` $$
' at line 1