Snowflake Vs MS-SQL - Series

Snowflake Vs MS-SQL - Series

Part 0 - Snowflake Key Concepts - Part 0

Part 1 - Different Versions of Stored Procedure - Part 1

Part 2 - Trailing Comma in Select Statement - Part 2 

Part 3 - Temporary Tables - Part 3 

Part 4 - Truncate and Insert - Part 4

Part 5 - Top n rows - Part 5 

Part 6 - MAX among columns - Part 6 

Part 7 - IF NOT EXISTS at Column Level - Part 7

Part 8 - The value of another column for the MAX value - Part 8 

Part 9 - Count based on condition - Part 9 

Part 10 - Single-level IIF - Part 10

Part 11 - Undrop - Recover objects - Part 11 

Part 12 - Hierarchical Data and CONNECT BY - Part 12

Part 13 - Create Table - Part 13

Part 14 - Clone Table - Part 14 

Part 15 - Exclude - Part 15 

Part 16 - Delete the Records - Part 16

Part 17 - Compare Data from Two Tables - Part 17 

Part 18 - Environment-wise appearance - Part 18 

Part 19 - ILIKE - Selecting all columns with names that match a pattern - Part 19

Part 20 - Separate out Number from String - Part 20 

Part 21 - DayName - Part 21 

Part 22 - Dynamic Query Execution - Part 22

Part 23 - Drop Stored Procedure - Part 23 

Part 24 - Column Alias - Part 24  

Part 25 - Variables - Part 25

Part 26 - QUALIFY - Part 26 

Part 27 - Lateral Join - Part 27 

Part 28 - CONCAT - Part 28

Part 29 - TRANSLATE - Part 29 

Part 30 - DECODE - Part 30 

Part 31 - String Aggregate  - Part 31

Part 32 - Else IF - Part 32 

Part 33 - INITCAP - Part 33 

Part 34 - NTH_VALUE - Part 34

Part 35 - iLike ANY - Part 35 

Part 36 - SPLIT_TO_TABLESPLIT_TO_TABLE - Part 36

Part 37 - GROUP_BY_ALL - Part 37

Part 38 - IFNULL - Part 38 

Part 39 - EQUAL_NULL - Part 39 

Part 40 - Stored Procedure Call - Part 40

Part 41 - NVL2 - Part 41 

Part 42 - Search Data - Part 42 

Part 43 - Swap Tables - Part 43

Part 44 - Select a Column using column order - Part 44 

Part 45 - Select data from a table - Part 45 

Part 46 - RATIO_TO_REPORT - Part 46

Part 47 - DUPLICATE_COUNT - Part 47 

Part 48 - Using - Part 48

Part 49 - NATURAL JOIN - Part 49 

Part 50 - LATERAL JOIN - Part 50

Part 51 - STARTSWITH - Part 51

Part 52 - ORDER BY NULL - Part 52 

Part 53 - CONTAINS - Part 53 

Part 54 - RANDOM - Part 54

Part 55 - POSITION - Part 55 

Part 56 - DATA TYPE CONVERSION - Part 56 

Part 57 - Affected Rows - SQLROWCOUNT - Part 57

Part 58 - Number Generator - Part 58 

Part 59 - GET_DDL View Code - Part 59 

Part 60 - Divide by Zero - Part 60

Part 61 - Data Type in Grid - Part 61 

Part 62 - Derived Column - Part 62

Part 63 - ON Clause & Cross Join - Part 63

Part 64 - ALTER Table ADD Column - Part 64 

Part 65 - SELECT records - TABLE - Part 65 

Part 66 - IS DISTINCT FROM - Part 66

Part 67 - Set Multiple Variables - Part 67 

Part 68 - Multi Table Insert - Part 68 

Part 69 - Flow Operator To Save Result-set Temporary - Part 69

Part 70 - UNION By Name - Part 70 

Part 71 - Data Is Numeric Or NOT - Part 71 

Part 72 - First Sunday Of The Month - Part 72

Part 73 - First Coming Sunday - Part 73 

Part 74 - Convert Column Into Comma Separated - Part 74  

Part 75 - String Length and Trimmed Length - Part 75

Part 76 - COLLATE - Comparing Text Strings - Part 76 

Part 77 - Remove Duplicates From String - Part 77 

Part 78 - Duplicate Rows Identification - Group By ALL - Part 78

Part 79 - Adding a comment to the Column of a Table - Part 79 

Part 80 - WHERE clause for multiple columns - Part 80 

Part 81 - First Day Of The Month - DATE_TRUNC - Part 81

Part 82 - Generate Unique Identifier - Part 82 

Part 83 - Compare NULL - IS NOT DISTINCT FROM - Part 83 

Part 84 - EXTRACT Day/Month/Year - Part 84

Part 85 - UNION ALL BY NAME - Part 85 

Part 86 - Modulus/Modulo Function - Remainder - Part 86

Part 87 - UTC Time - CONVERT TIMEZONE - Part 87