SQL Server temporary stored procedures vs Snowflake anonymous stored procedures
Over the years, I’ve done some work with Snowflake. In fact, I got certified in it at one point, and I’ve stayed across its capabilities. I have friends that work there.
Overally, I found the SQL language that Snowflake offered to be pretty limited, and particularly at the time I spent the most time on it, it seemed to have gaps in what it provided.
One thing that fascinated me though was the idea of an anonymous stored procedure.
2025-04-22