Chapter 12: Fundamentals of CLR Stored Procedure Development

Overview

In the previous chapter, I showed you how to create a CLR database object both with and without Visual Studio 2005. In this section, I am going to focus on stored procedure development in managed code. By the end of this chapter you should be able to:

• Return a value from a stored procedure

• Declare and use output parameters

• Return a result

• Reuse the connection that is used by the current stored procedure to execute additional queries and batches

• Manage LOB parameters