I was suppose to believe as ResultSet can be used with execution of stored procedures only , but it can be used with execution of TSQL statements as well in SQL Server Denali.
EXEC ('SELECT Name, Object_Id, Type_Desc FROM SYS.OBJECTS')
WITH RESULT SETS
ObjectName VARCHAR(50),-- Changed ColumnName
ObjectId VARCHAR(10), -- Changed Datatype
ObjectType VARCHAR(20) -- Changed ColumnName
Do you know it already?
General Technology Tips · · · ·