Automatically Generating Stored Procedures in SQL Server 2005

Posted on 2006-05-12
Medium Priority
Last Modified: 2006-11-18
Does anyone know of way to automatically generate INSERT, UPDATE, and DELETE stored procedures in SQL 2005?
With all the new features that were added, I figured this would be available.
Question by:jet007
LVL 75

Expert Comment

by:Anthony Perkins
ID: 16672365
I can only hope not ...

Accepted Solution

bwdowhan earned 100 total points
ID: 16673197
Hi jet007,

I haven't seen, or heard, of anything built into SQL2005 (or any version) to auto generate stored procedures; however, there are programs you can buy to do this. Here is one that I found (I cannot vouch for its functionality and only provide the link as an example of something you might be looking for):


LVL 50

Assisted Solution

Lowfatspread earned 100 total points
ID: 16680548
i think i know where acperkins is comming from on this one...

apart from a very Simple Insert stored procedure...

how would you expect a generic UPDATE/DELETE procedure to work?

these will vary greatly dependant on the overall design and business function being addressed...

if you "know" can recognise comon functionality for your "current" business application area...
then you can decide whether it will be worth the effort to construct your own "stored porcedure generator"
for the process  or you may decide that a Basic Code template is the best way to go to achieve consistency between
your developers...


Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question