I would like to get all the names of the columns in a given query [SQL Textual Query] and also the columns that are in the SELECT clause in a Stored Procedure.
Is there any ways other than using REGEX to get these information from the SQL Server. I can give the name of the SP.
Kindly suggest me the best practice for getting this information while using
SqlDataReader in C#.