Chapter 3. Program databases by using Transact-SQL

This chapter covers programmability features in T-SQL. It starts with programmability objects like views, user-defined functions, and stored procedures. It then covers handling errors with the TRY-CATCH construct, and working with transactions. The chapter completes with coverage of handling of data types and treatment of NULLs.

Skills in this chapter:

Image Create database programmability objects by using Transact-SQL

Image Implement error handling and transactions

Implement data types and NULLs

Skill ...

Get Exam Ref 70-761 Querying Data with Transact-SQL, First Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.