Datameer Blog

Tag: SQL

Datameer vs. SQL

Low code vs SQL: What transforms data faster?

Datameer No-code vs SQL The scale, flexibility, and cost-efficiency of cloud data warehouses, such as Snowflake, give organizations an agile infrastructure. With this, they...

  • John Morrell
  • November 30, 2021

Datameer Offers Innovative New SaaS Data Transformation Solution

SaaS Data Transformation Solution Our team here at Datameer is proud to announce that we are offering an innovative new SaaS Data Transformation Solution for Snowflake.  Th...

  • John Morrell
  • October 8, 2021
SQL FAQ Feat

How to use IF condition in SQL SELECT statement?

In SQL Server, we have below two options to implement IF condition in SQL SELECT statement. CASE WHEN… THEN IIF Let us consider the following ‘student’ table. CREATE TABLE ...

  • How-Tos FAQs
  • February 1, 2019
SQL FAQ Feat

How to initialize an AUTO_INCREMENT column in MySQL

The value of AUTO_INCREMENT can be reinitialized using the below methods. ALTER TABLE… AUTO_INCREMENT TRUNCATE TABLE Let us consider the table below. CREATE TABLE student (...

  • How-Tos FAQs
  • February 1, 2019
SQL FAQ Feat

How to add an IDENTITY to an existing column in SQL?

There is no straightforward way to add IDENTITY to an existing column. We need to follow a series of steps to achieve this. There are two ways to do this. Creating New Tabl...

  • How-Tos FAQs
  • February 1, 2019
SQL FAQ Feat

How to get only the DATE part from the DATETIME in SQL Server?

In SQL Server 2008 and above, we can either use the CONVERT or CAST function to return the DATE part from the DATETIME datatype. -- using CONVERT function SELECT CONVERT(DA...

  • How-Tos FAQs
  • February 1, 2019