Creating Stored Procedures for SQL Server
I don't know which one is ready, but you can use a code generation tool like MyGeneration (free) or CodeSmith (paid) to create scripts that generate the correct SQL for you.
source to share
I have developed my own generator for SQL Server stored procedures. It's free. What and for whom is it needed?
SQLDJ SQL Server Stored Procedures Code Writer (SQLDJ Code Writer) is a rapid performance development tool, automated scripting of MS SQL Server scripting for Microsoft SQL Server developers, application and database engineers, and database administrators.
What is he doing? SQLDJ SQL Server Stored Procedures Code Writer automatically creates extended SQL Server stored procedures based on user-selected database, database schema, tables.
What types of stored procedures does SQLDJ Code Writer generate? SQLDJ Code Writer generates select, delete, update, update, list, list, search stored procedures. List of stored procedures List, ListAll, Stored procedure search supports custom paging. Stored Procedure Search supports custom table type parameters for SQL Server 2008, 2008 R2, 2012.
How to download? Visit http://www.sql-dj.com Register, then click Download-> Free License and download the 32-bit or 64-bit version. Upload your license file and you're ready to go.
Jan Abowski @SQLDJ
source to share
SSMS Tools generates CRUD available right in SQL Server Management Studio. I assume you will need to change the templates it uses to suit your tastes.
Also, I am using a heavily modified data-level generator as the sort ORM that also generates CRUD processes for existing tables. Again, you will have to update your code to meet your merge
.
They would be close to you on a turnkey basis.
source to share