Environment for building T-SQL Stored Procedures on Microsoft SQL Server.
Tips for using:
1. Click on the 'New Stored Procedure' button on the ribbon menu.
2. Create Input and Output Parameters (you can make drag-and-drop from opened tables columns, if you are logged on SQL Server already).
3. Create workflow structure for your stored procedure. The workflow item can be renamed by hitting F2 on the selected tree item.
4. Insert SQL subscript into the Block items.
5. By Loop and Branch items you have tu set control variable, operator, and value before the stored procedure script will be generated (the controls to set you can find under the tree structure).
6. If you need to set the control variable for loop or branching, insert the Block to set this variable before in the same workflow branch.
7. In case you need to move some item from one workflow item to another, you can perform this action using drag-and-drop in the procedure workflow tree.
8. In case you need to reoder the items in the same workflow branch, make double click on the item in workflow tree and then move the items in the graph to intended order (the ordering is set in up-to-down and left-to-right style).
9. Do not remove the predefined variables.
10. Whole generated script is read only, the changes have to be made in variable tables and procedure workflow items.
11. Finally, to save, (re)generate stored procedure script, sending to SQL server and run the procedure, hit F5.
IMPORTANT NOTE:
❗ The database account under which you are will try to log on into the SQL Server through this application must have sufficient permissions for creating and calling stored procedures. Otherwise the application does not have to work properly and stable.
OTHER NOTES:
● The application is dedicated to the Microsoft SQL Server only.
● Target architecture for installing: x86, x64
● The application have to be used on the screen with 100% scale setting.
● Available versions:
1.) NON-COMMERCIAL use only (in addition turns off after 15min since every launch, then restart is needed). Free download.
2.) COMMERCIAL USE. Paid.
Both of them are full featured.
✉ In case of any questions about the product do not hesitate to contact us at info@aplicsoft.com
Thank you for your interest in our product. For more products click on the "AplicSoft s.r.o. (Ltd.)" link.