Conclusion
Stored procedures are one of the most powerful tools that SQL Server provides you. Understanding them well and using them wisely will result in robust, secure, and well-performing databases. Stored procedures give you a security layer, encapsulation, reduction in network traffic, reuse of execution plans, and much more. SQL Server 2005 introduces the ability to develop CLR routines, eliminating the need to develop extended stored procedures and enhancing the functionality of your database.
Get Inside Microsoft® SQL Server™ 2005 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
