Tech-Discussion

Trigonometry Functions - Geometry We rarely need to use trigonometric functions during calculations. MS-SQL Server We can achieve it as follows: In  Snowflake ,   we use   SIN  as follows: For more details, refer to the  SIN  section. Yogesh Shinde LinkedInProfile <<< Back   Next >>> Snowflake Vs MS-SQL - Series     

  Split String into Different Columns Suppose your application stores the name of an employee as a full name, and while retrieving, you want to separate it out as first name, middle name & last name. MS-SQL Server We can achieve it as follows: In Snowflake ,  we can make use of SPLIT_PART  as follows: For more details, refer to the SPLIT_PART section. Yogesh Shinde LinkedInProfile <<< Back Next >>> Snowflake Vs MS-SQL - Series

Multi-Table Insert based on condition Usually, we insert the data into a single table; however, if you want to insert records into different tables based on a value. MS-SQL Server We can achieve it as follows: In  Snowflake ,   we can use  the same query as above; however, we can use   INSERT FIRST  as follows: For more details, refer to the  INSERT FIRST  section. Also, please refer to the earlier article regarding INSERT ALL -  LINK . Yogesh Shinde LinkedInProfile <<< Back   Next >>> Snowflake Vs MS-SQL - Series    

Create Table If Not Exists Whenever we are creating a new table, we must verify that the table is not already present. MS-SQL Server We can achieve it as follows: In  Snowflake ,    we can use it  as follows: For more details, refer to the  CREATE TABLE  section. Also, please refer to the earlier article on Create Table -  LINK . Yogesh Shinde LinkedInProfile <<< Back   Next >>> Snowflake Vs MS-SQL - Series  

Identify Data Type - SYSTEM$TYPEOF Sometimes, you have to find out the data type or nature of the data in the existing column during data analysis. MS-SQL Server We can do as follows: In  Snowflake ,  we can use  SYSTEM$TYPEOF  as follows: For more details, refer to the  SYSTEM_TYPEOF  section. Yogesh Shinde LinkedInProfile <<< Back   Next >>> Snowflake Vs MS-SQL - Series