O'Reilly logo

Exam Ref 70-761 Querying Data with Transact-SQL, First Edition by Itzik Ben-Gan

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

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