SQL Server EXECUTE Statement with RESULT SET
SQL Server 2012 introduced a RESULT SET clause to the EXECUTE statement.
It can be used to specify alternate data types and column names for result sets returned by an EXECUTED statement or Stored Procedure.
The examples in this article are based on the AdvetureWorks2014 database.
The following example shows its use with an ad-hoc query example.