In this chapter, you declared and used local variables. You learned about control-of-flow statements and learned how to use them to control program execution. You understood the purpose of views, stored procedures, user-defined functions, and triggers, as well as understood the guidelines and restrictions to designing each of these programmable objects. You also learned how to design, create, and use views, stored procedures, user-defined functions, and triggers. In the last section, you learned how to handle errors that occur within Transact-SQL batches and programmable objects using the TRY...CATCH
construct.
SQL Server 2014 Development Essentials
By :
SQL Server 2014 Development Essentials
By:
Overview of this book
Table of Contents (14 chapters)
SQL Server 2014 Development Essentials
Credits
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
Microsoft SQL Server Database Design Principles
Understanding DDL and DCL Statements in SQL Server
Data Retrieval Using Transact-SQL Statements
Data Modification with SQL Server Transact-SQL Statements
Understanding Advanced Database Programming Objects and Error Handling
Performance Basics
Index
Customer Reviews