Which method allows multiple result sets to be returned in SQL Script?

The method that enables multiple result sets to be returned in SQL Script is a procedure. Procedures in SQL Script are designed to handle complex operations, including the ability to define multiple output parameters and return multiple result sets, which can be advantageous in various scenarios, such as when you need to extract data from different tables or perform different calculations within a single execution.

While scripted calculation views also allow for complex data modeling, they are primarily focused on the representation of data rather than managing procedural logic and return types. Table functions and scalar functions serve different purposes—table functions can return a table output, but they are limited in that they can only return one result set at a time. Scalar functions focus on returning a single value, thus not supporting multiple results.

The flexibility of procedures to return multiple result sets makes them particularly useful in complex data processing and analytics tasks within the SAP HANA environment.