returning data from sys SP

[sarav2k]

Hi
I would like to execute system stored procedure(eg. sp_columns)from another stored procedure and want to get the record set for analysis.

will cursor be useful for this? How to do it?

Thanks in advance
sarav

 

[JJayUK]

Most system stored procedures that return recordsets can be invoked as part of an INSERT statement.

CREATE TABLE #DATA (
DATA CHAR(500) )

INSERT #DATA
EXEC master..xp_cmdshell('DIR *.*')

Will load the results of the DIR *.* operation into the table called #DATA.

I don't see why you cannot do this with the other ones as long as they provide output.

Hope this helps Regards,
JJayUK

 

[sarav2k]

JJayUK...
It is giving output.... but Now my question is.
Do we need to create the temp table with all the columns to match the executed SP?

Is that only way ? or Any other way?

Thanks
Sarav2k