Posts

Showing posts from April, 2025

Snowflake Vs MS-SQL - Part 65 - SELECT records - TABLE

Image
          SELECT records - TABLE To see the records from any table, you need to use the SELECT command. MS-SQL Server   If we want to fetch ALL records, then you can use the SELECT command as below: However, in  Snowflake,  this can be achieved in the same way as above; however, you can  use the  TABLE  command as below:  Yogesh Shinde LinkedInProfile <<< Back   Next >>>     

Snowflake Vs MS-SQL - Part 64 - ALTER Table ADD Column

Image
          ALTER Table ADD Column Business requirements change during development or even after the project goes live, and you want to add an additional column to the existing table. MS-SQL Server   If we want to add a new column to the existing table, it is always better to check whether it exists. For this, in SQL, you have to perform 2 steps as below: However, in  Snowflake,  this can be achieved in a single step.  Yogesh Shinde LinkedInProfile <<< Back   Next >>>