Often, stored procedures are used to return result sets. Although this is a very useful feature, you might sometimes want greater control over the names and data types of the columns being returned as part of the result set. SQL Server 2012 introduces the
WITH RESULT SETS clause, which enables you to redefine the names, data types, and properties of the columns being returned from the stored procedure.
Modifying the names, data types, or properties of the columns being returned from a stored procedure result set can be useful when you want to modify the results for a specific report or application. The
WITH RESULT SETS clause allows you to modify the name, data type, nullability, and collation of each column ...