May 2021 - All Things SQL

SQL Concatenate – Combining Columns in a Table

combine columns in sql, combining columns in sql, combining two columns in sql, concat 2 columns in sql, concat two columns in sql, sql combine columns, sql combining two columns, sql concat 2 columns, sql concat two columns

We can combine multiple columns together into one in SQL using concatenation. Many databases have their own versions of combining

SQL INSERT – Using SELECT Statement

insert into table values select, insert into values select sql, insert using select sql, sql insert into values select, sql insert using select

We can write standard insert queries using hard-coded values. Similarly, we can write inserts and instead use a SELECT query

SQL INSERT Statement – Inserting Table Records

insert columns in sql, insert statement sql, sql insert statement

We are able to insert records into a database table using a SQL INSERT statement. Alternatively, we can utilize the

SQL UPDATE Statement – Modifying Table Records

sql update multiple columns, sql update statement, update multiple columns in sql, update statement sql

We can manipulate, modify or update records in a database table using a SQL UPDATE statement. Specifying a WHERE clause

SQL DROP – Tables, Views, Etc. – Deleting an Object

delete objects sql, drop objects sql, dropping objects sql, sql delete object, sql drop object

Separate from TRUNCATE and DELETE commands, we can use the DROP command to remove objects such as tables in SQL

SQL Case Statement Examples – Replacing If-Else

case statement sql, sql case statement, sql case statement examples, sql if else replacement, sql using case instead of if

Although some databases do support the IF ELSE functionality, the syntax can vary. The CASE statement can be used as