We help IT Professionals succeed at work.

Generating CRUD stored procedures

1,108 Views
Last Modified: 2012-05-05
Is there a free simple tool to generated standard CRUD (Create, Read, Update, Delete) Stored Procedures for a given MS SQL (2005) database? Just starting to code them by hand and it's a bit monotonous!
Comment
Watch Question

you can write one yourself
its pretty easy
you can get the metadata you need from
information_schema.columns

Commented:
I use Apex SQL Code:
http://www.apexsql.com/sql_tools_code.asp

Also Codesmith:
http://www.codesmithtools.com

P.S. There is no such thing as free software.

Author

Commented:
momo_sabag: I am quite new to SQL and C# programming so that might be beyond me at the moment I'm afraid. I guess I will have to code them by hand for now.

dportas: This is for a volunteer project so I'm afraid I don't have money to buy those tools. What do you mean there is no such thing as free software? Do you mean that somebody somewhere pays for it even if it's not the user?

Commented:
When you say "free" what you mean is free to licence. But the cost of a licence is only one part of the cost of software. Total cost of ownership also includes supporting, maintaining and using it. If your time is for free then I guess it's fair enough to say that the software is free too, I hadn't considered that.

Author

Commented:
"Free" also depends from whose persepctive you are looking! ;)
CERTIFIED EXPERT
Awarded 2008
Awarded 2008

Commented:
Here is an article I wrote on how to script out a table definition using TSQL.  If you take the code an alter it around a bit, you could come up w/ something to generate your CRUD statements...worst case, you just figure out a little bit more about the idea momi gave you.

http://blogs.techrepublic.com.com/datacenter/?p=431
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Awarded 2008
Awarded 2008

Commented:
You received several good comments...can't see why you would close this.

Author

Commented:
I'm not trying to be awkward I just can't see that anybody actually answered the question. I asked for a free simple tool. I got comments that recommended tools that weren't free. I got comments that recommended writing my own tool even though my stated level is beginner on this subject. My own comment actually gives links to free tools.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.