Daniel wrote:
>
> Hello,
>
> I've created a stored procedure in MSSQL. I'm not sure how to use it
> in SQLAlchemy. The stored procedure is called
> 'claim_highest_priority_work' and I can call it directly as follows:
>
> result = conn.execute('claim_highest_priority_work')
>
> I know it runs because I see the result in the database, but I'm not
> sure how to access the return values? They exactly match one of the
> tables I've defined.
>
> What's the right way to map/execute a stored procedure and
> subsequently access what it returns?
you probably want to select from it. an expression construct which
achieves this would be:
select([func.claim_highest_priority_work()])
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
