Articles → SQL SERVER → Sp_Describe_First_Result_Set Stored Procedure In The SQL Server

Sp_Describe_First_Result_Set Stored Procedure In The SQL Server

In this article, we will discuss the sp_describe_first_result_set stored procedure in the SQL server.

Purpose

If the stored procedure is returning multiple result sets, then the procedure sp_describe_first_result_set returns the result from the first result only.

Sample Stored Procedure

Consider the following stored procedure: -

create proc sp_describe_first_result_set_demo
As
Select * from sys.objects where type='p'
Select * from sys.objects where type='u'

The stored procedure returns the 2 result sets.

Execute The Stored Procedure

Execute the stored procedure using the sp_describe_first_result_set.

EXEC sp_describe_first_result_set @tsql= N'EXEC sp_describe_first_result_set_demo'

Output

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Saturday, October 28, 2023

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**