All Things SQL Archives - Page 2 of 2 - All Things SQL

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

ALTER TABLE – Add, Remove, or Modify Column in SQL

add column sql, alter table add column, alter table add sql, alter table drop column sql, modify column in sql, rename a column in sql, sql add column, sql alter table drop column, sql modify column, sql rename column

We can use the ALTER TABLE command to either add or remove columns in SQL. The ALTER command is considered

Create a Table Using a SQL SELECT Statement

create table using select, create table using select in sql, create table using select statement, create table with select, create table with select sql, create table with select statement, sql create table select, sql create table using select, sql create table with select

There are several ways to create tables with special keywords such as specifying primary keys, foreign keys, unique constraints and

5 Reasons Why We Should Use SQL Views

purpose of a sql view, purpose of sql views, reasons for sql views, reasons to use sql views, sql view, sql view purpose, view in sql, view sql, views in sql, why use sql views

SQL views are very powerful when used properly. They allow us to store our SQL queries into virtualized containers (aka

DML vs DDL Using SQL – What’s The Difference?

0 Comments ddl and dml in sql, ddl commands in sql, ddl dml, ddl vs dml, dml commands in sql, dml ddl, dml vs ddl, sql ddl dml, sql dml ddl

To first understand the key differences between DML and DDL when writing SQL we should define what these two acronyms

What Does SQL Stand For? – Structured Query Language

sql abbreviation, sql definition, sql means, sql stands for, what does sql stand for

SQL – otherwise known as “sequel” – is a database programming language used to find answers in a database. There

Next →