|
|
Posted by helmut woess on 10/01/74 11:28
Am Wed, 5 Oct 2005 09:04:14 -0500 schrieb spiffo:
> Using Sql Srv 7
>
> I know I can use the system sp's sp_stored_procedures and sp_sproc_columns
> to determine all the sps in a db, and what input parms there are for a
> particular sp... but... if the sp returns a result set, is there a way to
> find out the stru of that in a similar manner???
I never put time in finding an answer for this question but my first
thought is, that it cannot be possible, because i can write a procedure
like this:
create stored procedure myRandom as
if datepart(s,getdate()) % 2 = 1 select 'field_1', 1
else select 123, 'last'
So what is the struct of the resultset? It changes every second!
bye,
helmut
Navigation:
[Reply to this message]
|