🔍 Crx搜搜
SQL Stopro
0.0
0

截图预览

概述
翻译

Database tool for visual building the 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 without time limit after launch. Paid. Both of them are full featured. ✍ One FRIENDLY REQUEST at last: It would be highly appreciated if you could leave us a serious feedback (worthy of an IT professional) if you giving a rating for the app. If there is a possible issue with our app, please contact us first, to avoid any misunderstanding about correct using the app. Thank you in advance. ✉ 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.

特性

Visual stored procedure building in friendly way for programmers in imperative programming languages like C#, Java, etc. Tree hiearchy of stored procedure building blocks. Visualization of complex stored procedure building blocks. Many categorized T-SQL snippets available. Capability of quick launch of stored procedure with predefined and changed parameter values. Multiple table output as well as console output during the stored procedure execution. Structured T-SQL script generating with comments for complex building blocks boundaries. A visual control for visualization and datatype/value setting for input parameters, variables, and output parameters.

系统要求

适用平台:电脑, 移动电话, Surface Hub, HoloLens

操作系统:Windows 10 版本 17763.0 或更高版本

键盘:集成键盘

鼠标:集成鼠标

内存:1 GB

来自商店的评价 (0)

尚无人评价此扩展,查看 其他语言

留言