Please don't think that I am rude, I would certainly consider this to be a bad design. This adds unwanted complexity. To achieve this you need to first execute all queries, capture results into temp tables, and finally decide to serve it to the client based on the result of the whole batch.
Instead of adding this weired complexity to the database code, the client application can easily do it.
If you still want to do it this way, execute each statement within a try catch block and capture the output into temp tables. Finally, if all statements succeed, then serve data from the temp tables. If any statement fails, then serve "false"
commented on Aug 10 2012 6:06AM