Result Set Undefined In Sql Server. It was introduced in 2005. Raises an error if the Database Engine cannot determine the metadata for the first query that will be executed by performing a static analysis.
A user declares the local variable. RESULT SETS UNDEFINED This is the default and means that you dont know what the result set will be. Raises an error if the Database Engine cannot determine the metadata for the first query that will be executed by performing a static analysis.
Playing with WITH RESULT SETS will take you nowhere.
RESULT SETS NONE You expect and require that there will be no result sets returned. Used WITH TIES when you want to return two or more rows that tie for last place in the limited results set. RESULT SETS UNDEFINED is a default option with EXECUTE WITH RESULT SETS. EXECUTE WITH RESULT SETS with RESULT SETS NONE.