Is there any way to write to the screen in a Procedure, for troubleshooting purposes? I'm looking for the equivalent of DBMS_OUTPUT.PUT_LINE from Oracle. We'd remove it from production code, but it would be immensely useful for debugging a very large complex ETL procedure we have.
For external Stored Procedures and User-Defined Functions there is special "trace table" functionality available for debugging. For SQL SPs, you can add regular INSERT statements; GLOBAL TEMPORARY tables are often used.