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 student ( student_name VARCHAR(50), grade CHAR(1) ) INSERT INTO student SELECT ‘Jack’, ‘A’ UNION ALL SELECT ‘Rose’, ‘B’ UNION ALL SELECT ‘John’, ‘C’ UNION ALL SELECT […]
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 ( student_id INT PRIMARY KEY AUTO_INCREMENT, student_name VARCHAR(50) ); INSERT INTO student(student_name) VALUES (‘Jack’); INSERT INTO student( student_name) VALUES (‘Rose’); 1. ALTER TABLE… AUTO_INCREMENT We can […]
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 Table Creating New Column We need to convert the ‘student_id’ column of the table below to an IDENTITY column. CREATE TABLE student ( […]
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(DATE, ‘2010-12-20 22:52:43.133’) DateOnly — using CAST function SELECT CAST(‘2010-12-20 22:52:43.133’ AS DATE) DateOnly — Output DateOnly ————— 2010-12-20 In the older version of SQL Server, […]
The most simple way to escape a single quote in SQL Server is to pair it with another single quote. Below are some examples: — For selecting: [My name’s Jack.] SELECT ‘My name”s Jack.’ escaping_quote — Output escaping_quote ——————– My name’s Jack. — For selecting: [‘My name’s Jack.’] SELECT ”’My name”s Jack.”’ escaping_quote — Output […]
Before Oracle 12c, we don’t have a direct method of generating an AUTO_INCREMENT column in a table. We need to use the combination of Sequences and Triggers. Now, we have two different ways to implement it. Using IDENTITY column There are three options on IDENTITY COLUMN BY DEFAULT AS IDENTITY ALWAYS AS IDENTITY BY DEFAULT […]
You’ve decided to modernize your data and analytics stack and migrate analytics workloads to the ...
(This article first appeared on Medium on April 6, 2021.) The definition of “++” means incrementa...
More than just loading Data: Datameer launches Datameer Spectrum ETL++ to disrupt the no-code clo...