Product Review: Accelerate SQL Stored Procedures Generation using e Tek Global's SQL SP Generator
page 6 of 15
by Leonard Mwangi
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 41119/ 96

Defining Programming Standards

This tool allows you to define and standardize your procedure names and goes a step further to allow you to specify any keywords that need to be removed from the Stored Procedure name. For example, you might not want the prefix like "tbl" or "tlkp" in the procedure names, you can specify those keywords in the Choose Options Window as shown below.

Figure 3


If you look at Figure 3, you can see that the tool allows you to define the overall procedure prefix and suffix. For example, you can define pr_ as your prefix, which will attach pr_ to every procedure that will be generated. The Remove Keywords from Table allows you to define the words that should be excluded from the procedure name.

The tool makes it even more procedure specific where you can define the prefix and suffix for your Insert, Update, Delete, Get All and Get Single procedures.

Finally, the Choose Options step allows you to select whether you would like to have error handling on your script, whether you want to create Drop Script and also specify user permissions. The error handling will include the Try Catch block that has been introduced in SQL Server 2005.

These steps make my coding life easier because all my specified options are locally stored on my machine where it remembers my settings next time I am using the tool.

This gives the tool a big plus over others in the market.

View Entire Article

User Comments

Title: Good Tool   
Name: NW
Date: 2007-09-17 10:51:17 AM
This tool is awesome. Thanks for sharing the info.

Product Spotlight
Product Spotlight 

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2023  |  Page Processed at 2023-12-07 9:18:40 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search