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

Chapter 8. Stored Procedures

Stored procedures let you harness the full power of Microsoft SQL Server/MSDE. Stored procedures consist of SQL commands that can be supplemented with program commands like branches, loops, and so on. The program control elements are no longer an integrated part of the standardized SQL language, but instead they are Microsoft-specific extensions. Microsoft calls this programming language Transact-SQL. This chapter and the next one cover stored procedures and Transact-SQL. In this chapter we focus primarily on the use of stored procedures and the most important program commands. Chapter 9, “Transact- SQL,” introduces the many programming possibilities offered by Transact-SQL.

Stored procedures offer the following advantages:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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