Conclusion

In this chapter, you learned how to update existing rows with new or modified information. Moreover, you learned new procedures to ensure referential integrity plus how to manage the update process by using triggers. By combining the information contained in the last three chapters, you can now create complete applications by applying the best practices when using SQL Server 2005.