...\<App>\StoredProcedures

The StoredProcedures sub-folder contains the latest deployed version of database stored procedure code for each of the database tables used by the application.  Changes to the stored procedures will be overwritten when the application is built.

File

Function

p<App Name><Table>Add.sql
p<App Name><Table>Delete.sql
p<App Name><Table>DeleteRecords.sql
p<App Name><Table>DrillDown.sql
p<App Name><Table>Export.sql
p<App Name><Table>Get.sql
p<App Name><Table>GetList.sql
p<App Name><Table>GetStats.sql
p<App Name><Table>Update.sql

The database stored procedures that access the database table.

Examples:

            pOMSEmployeesAdd.sql
            pOMSEmployeesDelete.sql

LoadStoredProcedures.exe

An executable file to load the stored procedures into the database.  This executable file can be used during the Copy and Run operation when you are moving the application to a different location.  You must supply the database name, the user name and password and additional information about the stored procedures.
See Also

Transact-SQL Stored Procedures for Microsoft SQL Server