Databases

Stored procedures are a batch of SQL statements that can be executed in a couple of ways. Most major DBMs support stored procedures; however, not all do. You will need to verify with your particular DBMS help documentation for specifics. As I am most familiar with SQL Server I will use that as my samples. To create a stored procedure the syntax is fairly simple: CREATE PROCEDURE < owner >.< procedure name > < Param > < datatype > AS < Body > So for example: CREATE PROCEDURE Users_GetUserInfo @ login nvarchar ( 30 )= null AS SELECT * from [ Users ] WHERE ISNULL (@ login , login )= login A benefit of stored procedures is that you can centralize data access logic into a single place that is then easy for DBA's to optimize. Stored procedures also have a security benefit in that you can grant execute rights to a stored procedure but the user will not need to have read/write permissions on the underlying...