Use sys.sp_describe_first_result_set to show column information for a stored procedure.
exec sys.sp_describe_first_result_set '[dbo].[StoreProcedureName]';
Use sys.sp_describe_first_result_set to show column information for a stored procedure.
exec sys.sp_describe_first_result_set '[dbo].[StoreProcedureName]';