WITH RESULT SETS
The EXECUTE
statement has been extended in SQL Server 2012 to include the WITH RESULT SETS
option. This allows you to change the column names and data types of the result set returned in the execution of a stored procedure.
We will jump straight into an example to see how this works. The following procedure returns a straightforward result set using the Employee
table we created in the previous section:
CREATE PROC spGet_Employees AS SELECT EmployeeID, FirstName, LastName FROM Employee ORDER BY EmployeeID
If we call this stored procedure in the usual way it will return all columns. The data type of each column will be the same as the column type in the table.
EXEC spGet_Employees
In the previous section, we used the mySequence SEQUENCE ...
Get What's New in SQL Server 2012 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.