In a recent post, I discussed the GREATEST and LEAST functions in SQL Server 2022. Both of these functions exist in Snowflake, but after some testing, I found that they behave differently in Snowflake than in SQL Server when dealing with NULL values. While the functions behave differently, there are options to “get around” theContinue reading “Snowflake: Greatest and Least Functions”
Tag Archives: cloud
Snowflake: Overloading Stored Procedures
In a previous post, I discussed some of the struggles I had with converting a stored procedure from SQL Server to Snowflake – namely, the ability to set input parameters to default values. One way to get around this issue is to “overload” the procedure in Snowflake. Snowflake supports polymorphism whereas SQL Server does not.Continue reading “Snowflake: Overloading Stored Procedures”
Snowflake: Getting Started Stored Procedures
I’ve been primarily a SQL Server developer for the majority of my career, but along the way have needed to use a variety of database technologies including Oracle, Vertica, Teradata, PostgreSQL, and several others. A common behavior between them all is the ability to write some flavor of a stored procedure to encapsulate a blockContinue reading “Snowflake: Getting Started Stored Procedures”
Eric Heilman 