Home Forums SQL Server 2008 SQL Server 2008 - General How to get the resultset datatypes of a stored procedure ? RE: How to get the resultset datatypes of a stored procedure ?

  • February 21, 2012 at 4:01 am

    #1449569

    deepkt (2/21/2012)

    Thanks for the reply Eugene Elutin.

    Is there any other way without configuring Ad Hoc Distributed Queries option?

    Thanks

    No! There is none!

    But I still don't understand what you are trying to achieve. Why, in T-SQL, do you need to know the columns datatypes of recordset returned by stored proc?

    BTW, if you call stored proc, which returns recordset, from any client app (eg. reporting tools), you will know column datatypes straight away.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]