Tech-Discussion

         Multi Table Insert We insert data into a table, and sometimes, we must archive/back it up in another table. MS-SQL Server   We can achieve this by using magic or virtual tables present, like INSERTED,  as below: However, in  Snowflake, the insert statement has an additional clause,  INSERT ALL,  which allows you to insert into multiple tables:  For more details, you can refer to the following:  Multi_Table_Insert . Yogesh Shinde LinkedInProfile <<< Back   Next >>>        

         Set Multiple Variables Sometimes we get the values from table and assign to multiple variables. MS-SQL Server   We can achieve this as below: However, in  Snowflake,  this can be achieved in little bit different way as below:  Yogesh Shinde LinkedInProfile <<< Back   Next >>>       

          IS DISTINCT FROM In some cases, we need to get the records that are NOT mapping as below: And you are expecting the result as below: MS-SQL Server   We can achieve this by using INNER JOIN as below: However, in  Snowflake,  this can be achieved in the same way as above; however, you can use the  IS DISTINCT FROM   command as below:  For more details, you can refer to the following:  IS DISTINCT FROM . Yogesh Shinde LinkedInProfile <<< Back   Next >>>