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 115 -  Recursive View - Hierarchy   -  Part 115 Part 114 - Period Data Type - Part 114 Part 113 - Clear the cache - Part 113 Part 112 - Show Columns of a Table - Part 112 Part 111 - Extract a Year from the DATE - Part 111 Part 110 - Convert Data Type - Parse and Save XML - Part 110 Part 109 - Convert Data Type - Decimal to Integer  - Part 109 Part 108 - Filter Columns in Result Grid  - Part 108 Part 107 - Create or Alter Table - Add Column - Part 107 Part 106 - Table Structure - Describe - Part 106 Part 105 - PIVOT - Custom alias to column name - Part 105 Part 104 - Row Comparison - HASH - Part 104 Part 103 - ORDER BY ALL - SORTING - Part 103 Part 102 - Last Value in the Series - Part 102 Part 101 - Trigonometry Functions - Geometry - Part 101 Part 100 - Split String into Different Columns - Part 100 Part 99 - Multi-Table Insert based on condition - Part 99 Part 98 -  Create Table If Not Exists - Part 98 Part 97 - I...

          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 >>>