• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 23. Stored Procedures > Using Stored Procedures

Using Stored Procedures

Stored procedures are sequences of precompiled SQL statements stored in a database. These SQL statements are later referenced by name and executed at run time. Because stored procedures are precompiled, they run considerably faster than SQL, which is sent from a client application. They are sent via <cfquery>.

In addition to being faster, stored procedures are also more secure than normal SQL statements. Stored procedures can execute SQL on a table that a user does not have access to, and a database administrator can create procedures that hide certain columns of data or do calculations before data is returned.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint