[dba-SQLServer] MySQL not MS SQL question

Arthur Fuller fuller.artful at gmail.com
Mon Feb 25 16:41:35 CST 2013


I'm trying to stick with you on this, Stuart, but I don't understand what
you mean by "put the stored procedure in a pass-thru query. If the SP says
"SELECT * FROM someTables" then how do I "put it in"? SELECT FROM procName?
That doesn't make sense. Can you please explain?

TIA,
Arthur


On Mon, Feb 25, 2013 at 5:35 PM, Stuart McLachlan <stuart at lexacorp.com.pg>wrote:

> You can "Bind" the recordset from a stored procedure by putting that
> procedure in a
> pass-trhough query and "binding" to the query
>
> Note the quotes around "bind".  Recordset returned by  SPs are snapshots,
> there is no
> persistent connection.   So you only view/filter/sort the records.  You
> can't create/edit/delete
> any.
>
> --
> Stuart
>
>


More information about the dba-SQLServer mailing list