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 sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---