O'Reilly logo

Beginning SQL Server 2008 Express for Developers: From Novice to Professional by Robin Dewson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 11. Stored Procedures and Functions

Now that you know how to build queries written as single, executable T-SQL statements, it is time to look at how to place these into a stored procedure, or a function, allowing them to be run as often as they are required without the need to be retyped every time. It also allows code to be written that can accept input parameters and return a status, but, most importantly, allow you to improve the security of your database. You will see all of this and more in this chapter.

Stored procedures and functions are two different types of objects that provide different, yet similar, functionality. You will see these differences within the examples, but the main point is that a stored procedure is a set of code ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required