The SQL developer needs to be able to create processes for the working database by using one of the many programming objects (like functions, stored procedures, constrains, or triggers). By creating objects that talk with SQL you simply the way other programs (like applications or web pages) can interconnect. These eternal programs only need to call on the names of your programming objects by name rather than needing to submit large pieces of advance code.
With SQL Programming Development (Volume 4 of 5) in the SQL Server Joes 2 Pros development series, you learn how programming objects work in SQL Server. This book has been authored by Rick A. Morelan, Pinal Dave and Jessica Brown. If you are a SQL Developer, you may like the series of the book.