Stored procedures vs. parameter binding
Posted
by Gagan
on Stack Overflow
See other posts from Stack Overflow
or by Gagan
Published on 2010-05-13T14:58:53Z
Indexed on
2010/05/13
15:04 UTC
Read the original article
Hit count: 240
I am using SQL server and ODBC in visual c++ for writing to the database. Currently i am using parameter binding in SQL queries ( as i fill the database with only 5 - 6 queries and same is true for retrieving data). I dont know much about stored procedures and I am wondering how much if any performance increase stored procedures have over parameter binding as in parameter binding we prepare the query only once and just execute it later in the program for diferent set of values of variables.
© Stack Overflow or respective owner