Previous

Next

Summary

Completed

As demonstrated in this module, stored procedures offer several benefits including:

• Code reuse
• Security
• Quality improvements
• Performance improvements
• Reduced maintenance

In this module, you've learned how to:

• Execute stored procedures.
• Pass parameters to procedures.
• Create simple stored procedures using a SELECT statement.
• Construct and execute dynamic SQL with EXEC and sp_executesql.
• Create simple user-defined functions and write queries against them.

Continue