All pastes #940085 Raw Edit

necrite

public text v1 · immutable
·published 2008-03-12 19:24 UTC
rendered paste body
CREATE FUNCTION SAMPLE_FUNC( param1 VARCHAR(100)) RETURNS INT(11)
READS SQL DATA
BEGIN
    DECLARE id_val INT(11);
        SELECT id INTO id_val FROM t1 WHERE p = param1;
    RETURN(id_val);                                                                                  
END