Transact-SQL Stored Procedures for Microsoft SQL Server

Iron Speed Designer creates the following stored procedures for each database table and database view used in your application:

Transact-SQL Stored Procedures	Purpose
<PREFIX>Add	Insert a single record in the table.
<PREFIX>Delete	Delete a single record from the table.
<PREFIX>DeleteRecords	Delete a set of records based on search criteria.
<PREFIX>DrillDown	Get a list of distinct column values based on search criteria.
<PREFIX>Export	Export records from the table based on search criteria.
<PREFIX>Get	Get a single record from the table.
<PREFIX>GetList	Get a list of records based on search criteria.
<PREFIX>GetStats	Get summarized or calculated information from a table based on search criteria. Several possibilities include counting records, summing or averaging values.
<PREFIX>Update	Update a single record in the table.

<PREFIX>

Each procedure is uniquely named because Microsoft SQL Server (Transact-SQL) does not have the concept of a package. Each stored procedure name is prefixed with:

p<APP NAME><TABLE>

<APP NAME> is the name you assigned to the application when you created it.

<TABLE> is the name of the table upon which the procedure operates.

For example, the Add procedure for an Employee table in an application whose name is HR is named:

PHREmployeeAdd

Please note that if two developers are building applications using the same physical database on the same server, then they must use different application names for their respective applications. If the two names are the same, possibly because they are both working on the same application, then the stored procedures will have the same names and will be constantly overwriting each other's stored procedures. Iron Speed Designer does not generate Stored Procedures for dynamic queries used by QuickSelector, Charts and aggregate controls and uses instead inline code. If your application requires only using stored procedures without exceptions do not use these controls.

Parameter Restrictions

There is a 4K limit on parameters passed to stored procedures in Microsoft SQL Server.