how to return resultset from stored procedure?
Posted on 2004-10-18
not familiar with sql server stored procedures. i am only knowledgable in oracle and informix.
i need to know if it is possible to return a loaded resultset from a sql server stored procedure. i need to be able to do this from a single call to the stored procedure because these procedures will be called through odbc from linked query objects in microsoft access. using ADO an OLE to bind client cursor objects is not an option.
looking for an example of a simple stored proc that returns a first_name and last_name from an employee table with all employees with a last name started with var1; var1 will be passed in to the procedure at runtime. please demonstrate the call to the procedure and what the resultset should look like to the client. temp tables are not an option so please do not use that route.
thank you in advance.