Ars Technica

MSSQL Server 05: Stored Procedures - Output vs. Return values/parameters

This should be simple, but I'm a bit confused by these two.<br><br>As I understand it your stored procedure can have 3 values/paramater types:<br>Input paramters (which are obviously what you pass in, ...
Houston Chronicle

Stored Procedures Vs. Prepared Statements in PHP and MySQL

The PHP development language provides you with a "prepare" function to send a prepared statement to a SQL database. You can use full, inline SQL statements in the prepared statement function or send ...
Ars Technica

Reasons to use stored procedures

A while ago somebody posted in one of my threads six or so reasons to use stored procedures instead of raw SQL in asp applications. I know a couple of reasons, but a few of the reasons he listed I ...
Visual Studio Magazine

Speed Up Your Application with Stored Procedure and Temporary Tables

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 ...