• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 817
  • Last Modified:

Generating CRUD stored procedures

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!
0
Caltor
Asked:
Caltor
  • 4
  • 2
  • 2
  • +1
1 Solution
 
momi_sabagCommented:
you can write one yourself
its pretty easy
you can get the metadata you need from
information_schema.columns
0
 
dportasCommented:
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.
0
 
CaltorAuthor 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?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
dportasCommented:
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.
0
 
CaltorAuthor Commented:
"Free" also depends from whose persepctive you are looking! ;)
0
 
chapmandewCommented:
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
0
 
chapmandewCommented:
You received several good comments...can't see why you would close this.
0
 
CaltorAuthor 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.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

  • 4
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now