Solved

Generating CRUD stored procedures

Posted on 2008-10-03
10
741 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!
0
Comment
Question by:Caltor
  • 4
  • 2
  • 2
  • +1
10 Comments
 
LVL 37

Expert Comment

by:momi_sabag
ID: 22632412
you can write one yourself
its pretty easy
you can get the metadata you need from
information_schema.columns
0
 
LVL 22

Expert Comment

by:dportas
ID: 22632537
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
 
LVL 3

Author Comment

by:Caltor
ID: 22632561
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
 
LVL 22

Expert Comment

by:dportas
ID: 22632634
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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 3

Author Comment

by:Caltor
ID: 22632790
"Free" also depends from whose persepctive you are looking! ;)
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22633191
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
 
LVL 3

Accepted Solution

by:
Caltor earned 0 total points
ID: 22755985
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22756787
You received several good comments...can't see why you would close this.
0
 
LVL 3

Author Comment

by:Caltor
ID: 22757381
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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

706 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now