How to Call a Stored Procedure From PHP in MySQL. Stored procedures provide PHP programmers with pre-programmed database applications that retrieve and edit MySQL records. Stored procedures let ...

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.

Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which one is best for your particular situation.

Even better, these examples show how to pass XML data to stored procedures, and how they can be made to read single or multiple sets of criteria easily, using only a few lines of TSQL.