Stored Procedures—Part 2
The last chapter taught you pretty much all you need to know to start creating stored procedures. We’ll enhance that knowledge in this chapter by introducing user-defined data types (UDT for short) and taking a detailed look at set-based logic. It’s one of the most important things you need to understand as a database developer, and once you understand it your database development skills will accelerate—fast!
Enhancing the InsertContact Stored Procedure
The InsertContact stored procedure we created in the last chapter is pretty solid now. Not only does it create a contact and return the ID for that contact ...