Snowflake Vs MS-SQL - Part 1
Different Versions of Stored Procedure I've spent a lot of time developing MS-SQL Server code. After I started working on Snowflake, I experienced a different approach to the same thing. Here I am trying to list various aspects of Snowflake compared to MS-SQL Server. In MS-SQL Server, with same name you can create SP which will return two different results based on the call. It is not overloading. A. First Version B. Second Version When you will execute this SP, you will get the output similar like this: Code inside Stored Procedure will look like this: If you search under Object Explorer, you will find only one instance. In Snowflake, you can create two instances of Stoerd Procedure with same name A. First Version B. Second Version When you will execute these SPs, you will get the output similar like this: If you search under Object Explorer, you will find two instances. Pl...