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:
Create database programmability objects by using Transact-SQL
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.
