O'Reilly logo

Microsoft® SQL Server™ 2005: Database Essentials Step by Step by Solid Quality Learning

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required