Menu
I am looking for tool which will generate the basic stored procedure structure (CRUD operations) for the given table, Is there any tool for the same?
529
Expand Databases, expand the database in which the procedure belongs, and then expand Programmability. Expand Stored Procedures, right-click the procedure to remove, and then click Delete.
Using SQL Server Management StudioExpand Stored Procedures, right-click the procedure and then select Script Stored Procedure as, and then select one of the following: Create To, Alter To, or Drop and Create To. Select New Query Editor Window. This will display the procedure definition.
Right click on the stored procedure in the left menu, Select sql server from the drop down menu, Then select script procedure from the sub-menu.
There is no difference. That is, it's optional. BEGIN / END is optional, you can add them anywhere (without any IF, WHILE blocks...).
For MS SQL there is SSMS Tools Pack, works great!
185
Some stored procedure generators:
General use
SQL Server-specific
See also 1 and 2.
32
If you want to generate stored procedures to access your relational database system, you should look at CodeFluent Entities which is free for personal and see if it can meet your needs.
This tools allows you to generate tables, stored procedures and views with relative ease and it supports Microsoft SQL Server, Microsoft SQL Azure, Oracle, MySQL and PostgreSQL.
28
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
