Writing Stored Procedures for Microsoft SQL Server

Conclusion

In this chapter, you got a look into some of the rules you must follow when you create stored procedures. First, you saw how stored procedures are created and added to the server. Next, you saw how stored procedures are pulled from the server, compiled and executed. Lastly, you tackled the rules for identifiers and some suggested conventions for naming variables and other objects in your databases. Some of these rules are enforced by SQL Server. Other rules, such as the naming conventions, are not. These rules simply make your life easier during development of the procedures.