Stored Procedure - How To RETURN A Value/Expression/Table | Snowflake Stored Procedure | Ch-09

[@Praveen_Kumar_R_CBE]

Very well articulated scenarios.. thanks for sharing

[@ApoorvSaxena889]

Nice Explanation of Return Keyword with all possible scenarios. Waiting for the next set of video.

[@DataEngineering]

Keep watching

[@ipsna2758]

Hi , I’ve been trying to find how to print message in language sql scripting except return ‘text’ there isnothing else but return will break the code . How to print consecutive text messages?

[@DataEngineering]

There is no direct print feature.. alternatives 1. just run a immediate execute 'select "my-log-msg" and that will appear in your query profile 2. there is a logging feature, that captures your event log like any other programming language 3. else, you have to have it concatenated in a string and that string will be return.. (only if the execution is finally done as expected)

[@UPavan07]

Will you explain this Stored proc with Argument in this playlist

[@DataEngineering]

yes.. will do it..

[@narayanana3970]

It's been around 20 days...When can we expect next video...Pls post soon

[@DataEngineering]

Thanks for your note... the next video will be released tomorrow at 9PM IST.