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.
Any relational database server, such as SQL Server 2005, is essentially a data repository. As you discovered in previous chapters, you design ...