sqlalchemy execute sql with TOP parametrized

Question

I want to use limit in mssql, which is TOP, parametrized. I hoped I can get top parametrized like that:

engine.execute( text("select top :t * from Orders), t=100)

but I get: Statement(s) could not be prepared. (8180) (SQLExecDirectW)') 'select top ? * from Orders' (100,)

With top fixed or out it works fine.

Any ideas?

Community · Accepted Answer · 2017-05-23 12:14:49Z

3

As indicated in this answer, assuming you are using at least SQL Server 2005, you should be able to run:

engine.execute(text('select top (:t) * from Orders'), t=100)

SQL Server should accept the parameter as long as it's enclosed in parentheses.

CommunityBot

11 silver badge

answered Jun 9, 2012 at 12:19

ig0774

41.6k3 gold badges61 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1