Files generated by the Extended Stored Procedure Application Wizard are a starting point for creating an extended stored procedure. Add your own code to enhance the generated extended stored procedure function. You can also add more exported functions to the project and have several extended stored procedures contained within a single DLL.
Typically, you will use Open Data Services (ODS) and Win32 API calls to enhance your extended stored procedure. For more information about programming with ODS, see in the SQLВ Server documentation.