O'Reilly logo

Introducing SQL Server by Mike McQuillan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 19

image

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required