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?

Published under: General Technology Tips ·  ·  ·  ·