O'Reilly logo

Microsoft SQL Server 2014 Unleashed by Paul Bertucci, Alex T. Silverstein, Chris Gallelli, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 2014 provides 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 returned, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required