How Extended Stored Procedures Work

重要事項：
未來的 Microsoft SQL Server 發行版本將不再提供此功能。請勿在新的開發工作中使用此功能，並且儘速修改使用此功能的應用程式。 Use CLR Integration instead.

The process by which an extended stored procedure works is:

When a client executes an extended stored procedure, the request is transmitted in tabular data stream (TDS) or Simple Object Access Protocol (SOAP) format from the client application to Microsoft SQL Server.
SQL Server searches for the DLL associated with the extended stored procedure, and loads the DLL if it is not already loaded.
SQL Server calls the requested extended stored procedure (implemented as a function inside the DLL).
The extended stored procedure passes result sets and return parameters back to the server by through the Extended Stored Procedure API.

請參閱