|
|
In this chapter you learned about the following database objects:
Views
Stored procedures
Triggers
Although you are able to create all of these objects using SQL code, SQL Server provides a number of visual tools to help you achieve any task you may decide to undertake with these objects. The SQL Query Analyzer is a powerful T-SQL development tool that you can use to write and test your SQL scripts.
Views, stored procedures, and triggers can be used together to generate a powerful database solution that hinges on efficient business rule enforcement.
|
|