Stored Procedures—Part 1

  • Mike McQuillan


Stored procedures—or SPs, as some lovingly call them—are likely to become your best friends as you spend more and more time with SQL Server. It is not uncommon to come across databases that contain hundreds of stored procedures—they’re just so darned flexible! In this chapter, we’ll find out exactly why stored procedures are so useful, and we’ll create a couple of SPs of our own.


Output Parameter Select Statement Query Window Print Statement Store Procedure 

Copyright information

© Mike McQuillan 2015

Authors and Affiliations

  • Mike McQuillan
    • 1
  1. 1.WinsfordUK

Personalised recommendations