The easiest code to generate is stored procedure scripts. Stored procedures tend to closely follow a pattern, have a high payback for code generation, and give rapid feedback. It’s easy to execute the scripts that compile stored procedures and place them in your database right after you generate the scripts. Stored procedure scripts also tend to be relatively small and simple, making this the ideal place to start with code generation templates.