Цитата:
Say, my return procedure returns an integer:
Your procedure cannot return value (Transact-SQL ?).
Function can return value. If you use a function, I recommend to write:
PHP код:
cmd.commandType(1); //adCmdText, see ObjectBrowser in VBA
parameter = "Parameter value";
cmd.CommandText(strfmt("SELECT spTestReturnRecordset '%1'", parameter));
as wrote Ace of Database, but do replace EXEC on SELECT