[sqlalchemy] Re: Create a stored procedure using SQLAlchemy

2009-05-22 Thread Daniel
Thanks. This works great. On May 20, 4:54 pm, Clovis Fabricio wrote: > 2009/5/19 Daniel : > > > Hello, > > I have a stored procedure for SQL Server and I would like to be able > > to execute the code to create the stored procedure using SA.  Here's > > the basic idea. > > The problem is that I'

[sqlalchemy] Re: Create a stored procedure using SQLAlchemy

2009-05-20 Thread Michael Trier
Hello, On Tue, May 19, 2009 at 2:23 PM, Daniel wrote: > > I have a stored procedure for SQL Server and I would like to be able > to execute the code to create the stored procedure using SA. Here's > the basic idea. > > engine = sqlalchemy.create_engine('mssql://connectionString') > engine.execu

[sqlalchemy] Re: Create a stored procedure using SQLAlchemy

2009-05-20 Thread Clovis Fabricio
2009/5/19 Daniel : > Hello, > I have a stored procedure for SQL Server and I would like to be able > to execute the code to create the stored procedure using SA.  Here's > the basic idea. > The problem is that I'm getting an error complaining about invalid > syntax "ProgrammingError: (ProgrammingE

[sqlalchemy] Re: Create a stored procedure using SQLAlchemy

2009-05-19 Thread Michael Bayer
seems like a limitation of the DBAPI in use. have you tried creating a test script using just raw (pyodbc | adodbapi | pymssql) ? On May 19, 2009, at 2:23 PM, Daniel wrote: > > Hello, > > I have a stored procedure for SQL Server and I would like to be able > to execute the code to create the