Joe Conway wrote:
Gavin Sherry wrote:
Do you have any idea about databases returning result sets from SQL procedures (ie, not functions).
As other's have pointed out, this is very common in the MS SQL Server world (and I believe Sysbase also supports it). It works like:
And these databases also return a result status/value from the stored procedure. IIRC this result is limited to an int value.
Maarten
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match