Chapter 9. Retrieving Data Using Programmable Objects

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.

Introduction

Any relational database server, such as SQL Server 2005, is essentially a data repository. As you discovered in previous chapters, you design ...

Get Microsoft® SQL Server™ 2005: Database Essentials Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial