Select from mysql stored procedure -


since can not done :

select * (call my_stored_procedure(params)); 

is there alternative above statement ?

a procedure return multiple result sets, each own schema. it's not suitable using in select statement.

user-defined function option. here's example:

create function cubicvolume  -- input dimensions in centimeters  (@cubelength decimal(4,1), @cubewidth decimal(4,1),@cubeheight decimal(4,1) )   returns decimal(12,3) -- cubic centimeters.     begin    return ( @cubelength * @cubewidth * @cubeheight )  end 

more on link : http://msdn.microsoft.com/en-us/library/aa175085%28sql.80%29.aspx


Comments