Microsoft® SQL Server 2008 R2 Unleashed

Chapter 44. Advanced Stored Procedure Programming and Optimization

IN THIS CHAPTER

• T-SQL Stored Procedure Coding Guidelines

• Using Cursors in Stored Procedures

• Nested Stored Procedures

• Using Temporary Tables in Stored Procedures

• Using Remote Stored Procedures

• Stored Procedure Performance

• Using Dynamic SQL in Stored Procedures

• Installing and Using .NET CLR Stored Procedures

• Using Extended Stored Procedures

Chapter 28, “Creating and Managing Stored Procedures,” introduced the basic syntax and features for creating, viewing, and maintaining stored procedures. This chapter delves into more advanced stored procedure features and programming methods and provides guidelines on how to develop more robust and better optimized stored ...