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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.