SQL Queries 2012 Joes 2 Pros Volume 4 – Query Programming Objects for SQL Server 2012
You can get the Five part SQL Server 2012 Joes 2 Pros Combo Kit for complete reference.
Why Buy this Book
As you get further into SQL you will discover areas you like more than others. Maybe your good at queries or performance tuning. It all comes down to writing code but that code needs to be in the right place. Code can become a function, stored procedure, Trigger, Cursor, or a script. What type of code is right for the different SQL objects can how to handle errors is what this book is all about.
Most actions within a database take place many times to satisfy many customers or partners. The SQL developer needs to be able to create processes for the working database by using one of many programming objects (like functions, stored procedures, constraints, or triggers). By creating objects that talk with SQL Server, you control the way other programs (like applications or web pages) can interconnect. These external programs only need to call on the names of your programming objects by name rather than needing to submit large pieces of advanced code. This limited number of handshakes to SQL often represent a safe and pre-set way into SQL and keeps data better protected.
Programming objects are the building blocks for software and business intelligence applications. Throughout your SQL development career, most of the code you write will be contained in these objects.
Chapter 1. Constraints
Chapter 2. After Triggers
Chapter 3. Other Triggers
Chapter 4. Views
Chapter 5. Updating and Maintaining Views
Chapter 6. Stored Procedures
Chapter 7. Stored Procedure Techniques
Chapter 8. String Functions
Chapter 9. Time Functions
Chapter 10. Logical and Analytical Functions
Chapter 11. User-Defined Functions
Chapter 12. SQL Error Messages
Chapter 13. Error Handling
Chapter 14. Dynamic SQL
Chapter 15. Cursors
Chapter 16. Summary of Volume 4