Problem solve Get help with specific problems with your technologies, process and projects.

Get stored procedure results for unknown fields

Learn how to insert stored procedure results for result fields that are unknown by using the programming library.

I've designed a database with a lot of stored procedures. I want to show result fields for each stored procedure in my program (which is written in Delphi) when the user chooses the stored procedure from a list and I don't know specifically which stored procedure is chosen. How can we insert results of a stored procedure whose result fields are unknown?
The programming library you are using to access the database will likely give you access to the metadata or schema of the returned data. For example, if you are using ADO.NET you can access the columns collection associated with the DataReader to get info on what came back.
This was last published in September 2007

Dig Deeper on SQL Server Stored Procedures

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.