Tagged: stored procedures
- September 13, 2012 at 7:45 am #1198
I was curious about stored procedures.
Since a select is generally used for selecting a range of data and then returning it to the computer, you generally will always return records unless the parameters have not been met.
Then with a insert, update and delete, you generally don’t return data afterwards.
But with a stored procedure, it can always be used for multiple functions within a sql database. I’ve currently got a stored procedure that is receiving data and then using it for other means within a stored procedure. But since I’ve not specified for it to return data, i wouldn’t think it would bring back this error message but it does.
So i was wondering if this error message is intentional or you’ve designed stored procedures to always bring back data?September 13, 2012 at 4:24 pm #6241
Dennis @ PerfectFormsBlockedSeptember 14, 2012 at 8:58 am #6243
I’m aware of the “Show error messages” fix but my boss wants to know why the software was showing the error since stored procedures don’t always bring back a result.September 14, 2012 at 9:05 am #6244
It’s just pure curiosity on our case. That is all.September 14, 2012 at 8:48 pm #6246
If no Data is returned we default the error message to No Data Returned or Empty result (I dont remember the exact text). This was intentional and leave the user to decide further. This would be happening mostly in relate to Stored Procedure because of the Un-Known of what the SP is doing.
You must be logged in to reply to this topic.