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






Purpose





Sample 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'





Execute The Stored Procedure




EXEC sp_describe_first_result_set @tsql= N'EXEC sp_describe_first_result_set_demo'



Output


Picture showing the output of sp_describe_first_result_set stored procedure





Posted By  -  Karan Gupta
 
Posted On  -  Saturday, October 28, 2023

Query/Feedback


Your Email Id
 
Subject
 
Query/FeedbackCharacters remaining 250