I have several stored procedures, like:
GET_ALL_NAMES this has no input parameters, but returns two columns, several rows
GET_SELECTED_NAME this has one varchar input parametes, returns two columns, zero, one or several rows, depending on the input value
I have spent a few hours searching for this, in vain.
I use ASP.Net, and know how to do this using command objects and the like, that is not the problem.
What I want is a *PURE* SQL syntax for calling stored procedures and getting results returned.