var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Return many tables
I've just got the assignment to write a stored procedure or function. It was requested to return 3 tables from that sp or function.
It is posible for sp or function to return many tables at once? if so, which of them is better (sp and function).
Thanks in advance for your help!
A function can only return one result set. A well designed stored procedure will only return one result set, although it is possible for a stored procedure to return multiple result sets.
You REALLY don't want to do this. A procedure that returns more than one result set is a sure symptom of bad design. When I see that in a database, it is a waring sign of amatuers at play!
Yes, though if all the result sets have the same structure then you might be able to use a UNION query to consolidate them. If that's what you want...
OK, I'll byte..
Who's the scrub that requested this?
Scrub? It sounds like a middle-management requirement to me.