Re: SQL Server parameter substitution

Randy Syring <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
Ken,

Are you saying you are using

EXEC sp_executesql ...

for every statement that comes through to your driver with parameters 
instead of sending it over directly as SQL?

---------------------------------------------
Randy Syring
Development&  Executive Director
Level 12 Technologies  <https://www.lev12.com/>  (formerly Intelicom)
Direct: 502-276-0459
Office: 502-212-9913

Intelicom is now Level 12 Technologies,learn more about our name change  <https://www.lev12.com/our-history>.
Please update your address book with my new email address.

Principled People, Technology that Works


On 02/27/2012 07:02 PM, Ken Collins wrote:
>> Please let me know if my understanding about parameterized SQL not being
>> supported by FreeTDS is correct.
> Even though I discuss this from a Ruby ORM perspective, I suggest reading this article.
>
> http://www.engineyard.com/blog/2011/sql-server-10xs-faster-with-rails-3-1/
>
> Our connection mode to SQL Server is on top of FreeTDS/DBLIB, so our implementation of sp_executesql and parameterized queries may be useful to you.
>
>
>   - Ken
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.