CRUD SP generator for SQL Server 2008 (R2)

2019-04-11 13:09发布

问题:

I am using SQL Server 2008 R2. Is there a free script/utility which can make CRUD SPs for all of my database tables? I use to have one but lost the script.

Thanks

回答1:

I use SSMS Tools Pack, a CRUD generator is only one of the many features it has that I use on a regular basis. You can also customize the templates it uses to create the CRUD SPs.



回答2:

You could always use something like MyGeneration. It's free and can do a lot more than just crud operations. If it doesn't have the templates you need you could always create them pretty easily.