Chapter 11: Stored Procedure Programming and Error Handling

Modern-day programming demands security and secure coding. If you are embedding your SQL inside the application (i.e., writing a SELECT/INSERT in the form itself) then the argument is often made that you are not writing secure or reusable code - both terrible things in today's environment. Check out these videos for more information on SQL Server stored procedure programming.