6a860029_Triggers__Inline_SQL__updated___Feature
[Rating] 3 –again in theory it can, but very hard to maintain since you would often be duplicating logic to say return one field in one situation and other set of fields in another situation or update a field when the field is passed in as an argument. Note that in many databases such as for example SQL Server and Oracle, one can return multiple result sets with a stored procedure, but the receiving end needs to be able to do a next result set call and know the sequence in which the result sets are being sent. [Feature] 
Can return varying number of fields given different arguments.
Choice Between Stored Procedures, Functions, Views, Triggers, Inline SQL (updated)
Feature