For example, you can create ... General Best Practices use SQL triggers, procedures, and functions: Document Your Code: Always add comments to explain why a trigger, procedure, or function exists ...

To read the full example, check out the post here: http://blog.bandwidth.com/attaining-reusability-in-sql-server-part-ii/ To run the example, you should first run the ...