Chapter 3: First Stored Procedure
INSTRUCTIONS FOR USING THIS ONLINE BOOK
Welcome to Salmon Training's Online Book "Developing Stored Procedures for Microsoft SQL Server ".
First of all, we suggest you BOOKMARK THIS PAGE to be able to return to it as often as you wish.
Our Online Books have a few special features for navigation through the book.
The menu on the top right lets you turn the page forwards and backwards using these keys:
<< previous |
next >> |
In the full version of this e-book, you can use the Table of Contents on the left-hand side of every page to jump to different chapters in the book. Within this sample chapter, the Table of Contents lets you jump to different section headings.
The book is designed to be used actively, and takes the reader through a real-world project to build a sales application database. Numerous code listings are provided, and the developer may copy-and-paste the code from browser to a SQL Editor.
Code listings for copy-and-paste are in light-green boxes. This example is executing a stored procedure called "customer report" - one of the many stored procedures developed in the full e-book.
exec customer_report
The output of code listings is displayed in light-blue boxes to show the results obtained on the the authors' development database.
customer_name number_of_orders Joe Smith 2