Stored Procedures, Functions, and Security

  • Robin Dewson


Now that you know how to build queries written as single executable lines of T-SQL statements, it is time to look at how to place these into a stored procedure or a function within SQL Server, 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, return a status, return rows of data, and, most importantly, allow you to improve the security of your database. You will see all of this and more in this chapter.


20B4 Statement Database User Security Context Store Procedure Application Role 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Robin Dewson 2012

Authors and Affiliations

  • Robin Dewson

There are no affiliations available

Personalised recommendations