Available at

USA: Amazon

India: Flipkart | IndiaPlaza

eBook: Kindle

Others: books ‘at’ SQLAuthority.com

Introduction

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.

Table of Content

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 User-Defined Functions
Chapter 9 SQL Error Messages
Chapter 10 Error Handling
chapter 11 Change Tracking
Chapter 12 Change Data Capture
Chapter 13 Performance Tips by Pinal Dave
Chapter 14 Next Steps for Aspiring SQL Pros

[Amazon] | [Flipkart] | [Kindle] | [IndiaPlaza]