Free SQL Server Stored Procedure Generator?

Question

I saw some SQL Server stored procedure code generator that generates scripts when a table is selected.

Please recommend the free tool that SQL Server SP generates, but I'm looking for:

• It generates scripts in db where the user may not need to copy the code and execute the script in db.
• It can generate SP for the selected scheme, I mean that the user may not need to select the table one by one, just by selecting db, he can generate scripts for all tables.

thank

Answer 1

Try

http://www.codeproject.com/KB/database/Store_Procedure_Generator.aspx

Answer 2

SSMS . sql-.

:

• SQL-
• .
• , ,
• SQL
• ,
• script
• Insert ,
• CRUD (, , , )

Answer 3

.

www.metadrone.com

google : http://code.google.com/p/metadrone/source/browse/trunk/Templates/SQLServer_CRUDs.mdrone

script runcript MAIN. :

call CRUDs(sources.SQL_Server)
runscript(sources.SQL_Server, "\path\goes\here\tablecruds.sql")

Answer 4

:

• CodeSmith Generator -
• MyGeneration -
• Metadrone -

SQL Server

• SSMS

. 1 2.

Answer 5

Tangential - , , , CRRO sprocs (MS Access MS SQL Server 2005), , .

, . ADO.NET, LINQ EF.

If you do not find what does what you need, do a punch.

What I came up with was semi-brute and brute force, but the process was quite educated.

Since then I have expanded it to create a CREATE script for MS Access databases (which Access does not provide out of the box).