What are the real time uses of the Denali's With Result Set so far Sql Stored Procs are concern apart from renaming the column names and data types at runtime.
Even what is the benefit of changing the datatypes at runtime in With Result Set
Alter PROCEDURE test_Proc AS BEGIN SELECT * FROM tbl_Test END GO EXEC test_Proc WITH RESULT SETS ( ( Id int, EmpName varchar(50), PNo varchar(50) ) )
Even if the column datatypes has been changed, what will we do with that?
however this article gives some idea about it's benefit in SSIS. But I am more interested in Sql Server stored Proc talking to any front end application(e.g. c#) and the like prespective.