Chapter 9: Retrieving Data Using Programmable Objects

 Download CD Content

Overview

After completing this chapter, you will be able to:

• Create functions that work like built-in Microsoft SQL Server 2005 functions

• Develop stored procedures, which are small programs stored inside Micrososft SQL Server 2005 that query and update databases

• Develop programs using T-SQL, Visual Basic.NET, or other .NET Framework languages

• Know when programmable objects are best used

In this chapter, you will learn that Microsoft SQL Server 2005 can be more than simply a data repository. It is possible to write programs to run inside SQL Server 2005.