Thursday, September 28, 2017

Get the schema for a result set from a query or sproc


https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-describe-first-result-set-transact-sql

https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-describe-first-result-set-transact-sql

EXEC sp_describe_first_result_set @tsql = N'exec sys.sp_who'
GO
SELECT * FROM sys.dm_exec_describe_first_result_set( N'exec sys.sp_who', null, 0)
go