Metadata about current query

• bartedgerton

  SSCrazy

  Points: 2062

  More actions

  October 21, 2015 at 4:07 pm

  #321709

  I'm curious if there is a way to gather any metadata about a query that was just ran, or about a dynamic query passed in as a parameter, such as being able to "dynamically" return a list of columns in the query, along the lines of:

  SELECT * FROM [myTable];

  SELECT @@COLUMNS --Expecting this to return a recordset of columns for the previously run query

  I'm not talking about querying metadata about the tables themselves, I'm really looking for what "metadata" might be available about the query itself.

  This would be useful for me to dynamically generate some code for ad-hoc queries with a stored procedure call, or to simply return a list of just column names only without the data.

  Am I dreaming, or is this at all possible in SQL Server?

• mister.magoo

  SSC-Forever

  Points: 47174

  More actions

  October 21, 2015 at 5:17 pm

  #1834796

  exec sp_describe_first_result_set N'select top 10 * from [myTable]'

  MM
  

  ---

  
  select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

• Forum Etiquette: How to post Reporting Services problems
[/url]
• Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]
• How to Post Performance Problems - by Gail Shaw
[/url]