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.
Dig Deeper on SQL Server Stored Procedures
Related Q&A from Greg Low
If you're working with SQL Server 2000 and trying to find a disabled index, here's something you should know.
Should developers be granted permissions to production queue in a SQL Server environment? See why expert Greg Low suggests proc access by WITH ...
Find how to save stored procedure output to the network drive via SQL Server Management Studio.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.