Processing Method
-
If fix-SQL Editor is running and you're looking at a set up form you haven't yet created a Project. Get information here on how to do this. Get Started page.
fix-SQL Editor gathers all the information you need when you're writing code to execute a stored procedure. The process is very simple, just load the Stored Procedure name into the Tables and Aliases Treeview, it will auto complete to help you locate what you need. When you add a Stored Procedure to this list the named parameters and the return type for the procedure are listed in a sub node.
Right Click the procedure from the list that you want to use and then select 'Display Stored Procedure Definition' which displays the create script for the SP or 'Process Stored Procedure' to create some ado.net code that will demonstrate the execution call and parameters for the procedure. You will probably edit this code it's purpose is to provide the named parameters and execution code formatted for .net useage which you can use to save some time.
Security
You need to have Sql Server permissions to access the database Schema.
-
The latest security compliance standards mean many companies are looking at converting dynamic SQL queries to Stored Procedures. fix-SQL Editor will have new functionality for Stored Procedure conversions in the next release update.
-
Current fix-SQL Editor capability enables writing and editing capability for Stored Procedures. This will be significantly upgraded.
-
Support for User Defined Types are used in parameters when they are registered in the database along with all schema's.
-
When queries are written out in the results pane no changes are made at all to any object in the database.