See Using DBMS Data with the SQL Pass-Through Facility for usage examples. The SQL Procedure Pass-Through Facility consists of three statements and one component: The CONNECT statement establishes a ...

A simple T-SQL stored procedure might only be a parameterized version of a SELECT statement. Its advantages are ease of use and efficiency. Stored procedures are optimized when they are saved ...