Stored Procedure Generator
-
Hello,
i am searching for a StoredProcedureGenerator-Tool to generate Insert, Update, Delete, and Select Stored Procedures (SQL-Server) for selected tables for a particular database.
what would you recommend? ....stand-alone or C # integration.
Best reagards
Nicole
-
the http://www.ssmstoolspack.com/ is free and very popular among some of the psoters here.
it has a built in CRUD generator, so you can right click on a given table and it will generate teh procedures youa re asking about.
you can find similar TSQL scripts in the Script contributions as well:
http://www.sqlservercentral.com/search/?q=CRUD+generator&t=s
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
thanks Lowell...
intresting thing to know
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/ -
info 58414 (10/22/2012)
Hello,i am searching for a StoredProcedureGenerator-Tool to generate Insert, Update, Delete, and Select Stored Procedures (SQL-Server) for selected tables for a particular database.
what would you recommend? ....stand-alone or C # integration.
Best reagards
Nicole
SSMS Tools pack can do that for you. It is a free SSMS plugin so you can generate them right inside SSMS. Once it is installed you can right click on the table in SSMS -> SSMS Tools -> Create CRUD.
--EDIT--
Bitten by the refresh bug.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/ -
I used to use CodeSmith. But that was when they were hosted on CodePlex. It's moved to GoogleCode [/url]and I'm not sure it's the same. Still, might be worth checking it. It worked great.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply