var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to do a SELECT on a Stored Procedure
create procedure `test`(a number,b number)
SELECT * from test(1,2);
Output should be 3
Here "test" is the name of the procedure. How to do this on MYSQL?? This works in SQL Server, but not on MYSQL.
I get 1064(42000) error in the line -SELECT * from test(1,2);
Last edited by Nagashree; 03-29-11 at 05:32.
The closest you can get to what you are trying to do is creating a function rather than a procedure:
Call the function you would issue:
CREATE FUNCTION test(a DECIMAL,b DECIMAL)
How to do a SELECT on a Stored Procedure
In MySQL Syntax to call procedure is,
In your case CALL test(1,2);