Generating feedback schema for a typed stored procedure, the stored procedure updated some databases before getting the last result Had gone. There is some garbage in the response schema generated by Visual Studio
Is there a way to force it to generate a clean schema?
stored Procurrores ResetSet 4 only There is only one thing.
Here is my answer to MSDN Unfortunately, there is no way, or in fact, in fact It is hard to capture and suppress the result set with a brief stored procedure, since the exact answers will not work for you.
The reason is related to the stored procedure code.
The wizard will only generate schema types for elements that have returned in response to SQL Server. Meaning, stored procedures are the results generated for those updates so you can get metadata for them.
The way to resolve this should not emit any result on any operation by modifying the SP code. Basically, if you see it in the results window in SQL Management Studio, you will get a schema for it.
The situation and the message is probably one way to suppress one result in order to assign results as a result of another SP, thus creating a redirect output stream for a temporary table.
However, if stored processing resultset4 is everything, you have to do this to use it. There is no glitch just to ignore all the other results, provided they always appear in that order.
To be clear now, you still have to type the wrapper which will suppress the unwanted results, just will not change the original SP to a new SP output, you will still get additional result sets.
In fact, a cover will be a hard implementation as you have to capture all the result sets and test them. I do not think it is possible.
To do this, BizTalk will have a more accurate way to port map which strips unwanted content.
No comments:
Post a Comment