Meta data of query?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: LCaffrey (lxc_at_eosys.ie)
Date: 07/11/04 

Date: 11 Jul 2004 04:14:42 -0700

Hi,

Take a typical query...

SELECT col1 as "my_first_name"
      ,col2 as "my_second_name"
      ,col3 as "my_telephone_no"
  FROM personal_details
 WHERE col2 = 'Caffrey'

When this is run in Query Analyzer or the SQL Window of EE, the column
headers are automatically given in the result set.

Is it possible to access this meta data in the executing script from
any of the sys tables. Would it be easier to parse the SQL statement.

Also, where is the meta-data of a result set of a stored procedure
stored or where or how is it obtained.

Regards

Liam Caffrey
lxc@eosys.ie

Relevant Pages

  • Re: Is sql server as good as access 97?
    ... Once you really get into using Query Analyzer for writing your ... Transact-SQL and for formulating 'queries' for exporting to your code, ... resulting stored procedure runs in a small fraction of the time it took to ... Unfortunately the database I am converting ...
    (microsoft.public.sqlserver.programming)
  • RE: Differences in execution times for a stored procedure
    ... If OleDb, ... "Vincent Keller" wrote:> I am trying to execute a time-consuming stored procedure in my application. ... > Are there some known performance differences in executing a query directly through Query Analyzer and through ADO.NET? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: "On Error Resume Next" in SQL Server
    ... When you are running your query in query analyzer, ... > would occur would be due to bad user input which does not ... > that my stored procedure will run to the end of the cursor? ...
    (microsoft.public.sqlserver.programming)
  • Re: Output Parameters Return Nothing
    ... >> when I query the output parameters, they return a value of Nothing. ... >> the stored procedure in Query Analyzer, ... >> Bob L. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Exception: The SqlTransaction has completed; it is no longer usabl
    ... > I hv encountered this exception 'The SqlTransaction has completed; ... returning around 9000 rows in a DataSet and back to the app. ... > When that exception is thrown, I tried running the same stored procedure ... > I was thinking if Query Analyzer can return data very quickly... ...
    (microsoft.public.dotnet.framework.adonet)