Solved

Generating CRUD stored procedures

Posted on 2008-10-03
10
745 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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

867 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

12 Experts available now in Live!

Get 1:1 Help Now