Abstract
So far, you have worked exclusively with tables by using Data Manipulation Language (DML) statements. You have learned to manipulate data by inserting new rows and updating or deleting existing rows. You can use many other objects in a SQL Server database to make your database applications more efficient and secure. This chapter teaches you how to add restrictions to tables and to create other objects that help to enforce key business rules. In this chapter, you will learn about Data Definition Language (DDL) statements and learn about constraints on tables, views, stored procedures, user-defined functions, and user-defined types. You will also learn about triggers, special objects that fire when data is modified. Because SQL Server provides so many choices for creating these objects, this chapter doesn’t attempt to explore every possible option. The chapter does, however, provide enough detail to teach you most of what you will encounter on your journey to becoming an expert T-SQL developer.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 David Guerineau
About this chapter
Cite this chapter
Shaw, S., Kellenberger, K. (2012). Moving Logic to the Database. In: Beginning T-SQL 2012. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3705-1_9
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3705-1_9
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3704-4
Online ISBN: 978-1-4302-3705-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books