Tech-Discussion

Replace the String - INSERT - STUFF If you want to delete a part of a string and then insert another string into the original string at a specified position. MS-SQL Server   We can achieve it as follows: In  Snowflake ,  we can use INSERT  as follows: For more details, refer to the  INSERT  section. Yogesh Shinde LinkedInProfile <<< Back   Next >>> Snowflake Vs MS-SQL - Series

Form the DATE from Parts DATE_FROM_PARTS If you want to form the date from Parts like Day, Month & Year. MS-SQL Server   We can achieve it as follows: In  Snowflake ,  we can use a similar approach as above; however, we can use  DATE_FROM_PARTS  as follows: For more details, refer to the  DATE_FROM_PARTS  section. Yogesh Shinde LinkedInProfile <<< Back   Next >>>  

Count of non-NULL records of the column using ILIKE If you want to get the Count of non-NULL records of the column. MS-SQL Server   We can achieve it as follows: In  Snowflake ,  we can use a similar approach as above; however, we can use  ILIKE  as follows: For more details, refer to the  ILIKE  section. Yogesh Shinde LinkedInProfile     <<< Back   Next >>>

Snowflake Vs MS-SQL - Series Part 92 -  Stop or Cancel the Running Query   -  Part 92 Part 91 -  ARRAY UNNEST - FLATTEN   -  Part 91 Part 90 -  Replace the String - INSERT - STUFF  -  Part 90 Part 89 -  Form the DATE from Parts DATE_FROM_PARTS  -  Part 89 Part 88 -  Count of non-NULL records of the column using ILIKE  -  Part 88 Part 87 -  UTC Time - CONVERT TIMEZONE  -  Part 87 Part 86 -  Modulus/Modulo Function - Remainder  -  Part 86 Part 85 -  UNION ALL BY NAME  -  Part 85   Part 84 -  EXTRACT Day/Month/Year  -  Part 84 Part 83 -  Compare NULL - IS NOT DISTINCT FROM  -  Part 83   Part 82 -  Generate Unique Identifier  -  Part 82   Part 81 -  First Day Of The Month - DATE_TRUNC  -  Part 81 Part 80 -  WHERE clause for multiple columns  -  Part 80   Part 79 -  Adding a ...

          UTC Time - CONVERT TIMEZONE Many times you get the time inthe local time zone, but you want to display the same time in UTC Time Zone. MS-SQL Server   We can achieve it as follows: In  Snowflake ,  we can use a similar approach; however, we can use  CONVERT_TIMEZONE  as follows: For more details, refer to the  CONVERT_TIMEZONE  section. Yogesh Shinde LinkedInProfile <<< Back   Next >>>