You can use full, inline SQL statements in the prepared statement function or send the database a stored procedure function. A stored procedure is a program that is stored on the database server.

Stored procedures can speed up your code by reducing trips to your database -- even if you only have one SQL statement to execute. Here's how to speed up your application (and how to simplify your ...

Although the CategoryID field is an integer we must convert the values sent to varchar so it can be properly parsed by the stored procedure. We are creating a dynamic SQL statement in order to ...