Exam objectives in this chapter:
Work with Data
Query data by using SELECT statements.
Troubleshoot & Optimize
Implement error handling.
Microsoft SQL Server is a relational database that strictly enforces transactional behavior on database changes in order to protect data integrity. This chapter presents the T-SQL code behind transactions, and extends that code to handling errors and using dynamic SQL.
Lessons in this chapter:
To complete the lessons in this chapter, you must have:
An understanding of basic database concepts. ...