Automatic Stored Procedure Generation in SSDT
In some organizations production apps are only allowed to communicate with a database through stored procedures, including basic features like SELECT, INSERT, UPDATE, AND DELETE. As a result, when creating a new table stored procedures must be created for each of those functions. While not difficult to do, it is incredibly tedious and time consuming when working with a lot of tables.
It would be nice if a SQL Server Data Tools (SSDT) project had the option to automatically script stored procedures for a table or a view. SQL Server Management Studio has a somewhat similar feature with Script As, however it would be nice to take it a step further by having the ability to generate input parameters as well.
Even without the development requirement mentioned in the first paragraph, the ability to automatically generate stored procedure scripts to some degree could greatly increase productivity and reduce the tedium of creating certain procedures.
Thanks for taking the time to share this suggestion. This item has been around for a couple of versions of Visual Studio and we haven’t acted on it. Looking at the VS “15” plans, we’re not going to take action on this item, so we’re going to close it. If the suggestion is still relevant, please either take a look to see if there’s another suggestion that’s similar that you can vote on, or open a new suggestion.
- The Visual Studio Team
Ajeet Pratap Singh commented
I have already created such tool.It will generate different types of stored procedure ,automatically with parameters(tables value and others)
I think this is called “hitting the target and missing the point”