Microsoft® SQL Server 2012 Unleashed

Using the WITH RESULT SETS Clause

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 ...