The DROP Statement in SQL – Tutorial
Thursday, July 14 2016
The DROP Statement in SQL: Overview You use the DROP statement in SQL to delete created database objects. You can use the DROP statement in SQL to delete databases, tables and indexes. You can also use the DROP statement in SQL in conjunction with the ALTER TABLE statement to delete fields
- Published in Access 2013, Latest, Microsoft, Office 2013, SQL
No Comments
The SELECT Statement in SQL- Tutorial
Monday, September 21 2015
The SELECT Statement in SQL: Overview You use the SELECT statement in SQL to choose specific records to view from a table, or from related tables, within a temporary table called a result set. We will start the examination of the SELECT statement by looking at the SELECT statement in its simplest form when
- Published in Access 2010, Access 2013, Latest, Microsoft, Office 2010, Office 2013, SQL
The UNION Operator in SQL- Tutorial
Wednesday, February 11 2015
The UNION Operator in SQL: Overview The UNION operator in SQL allows you to combine the result sets of two or more individual SELECT statements into a single result set. Note that the UNION operator in SQL is not a JOIN, but rather a way to combine the data within two result sets into
- Published in Access 2013, Latest, Office 2013, SQL
DROP USER and DROP ROLE Statements in SQL
Thursday, November 20 2014
DROP USER and DROP ROLE Statements in SQL: Overview This blog post discusses using the DROP USER and DROP ROLE statements in SQL. You can use the DROP USER statement in SQL to delete a user from the database. Note that this statement is technically classified as Data Definition Language (DDL), as it defines
- Published in Access 2013, Latest, Microsoft, SQL
The INSERT Statement in SQL- Tutorial and Video
Wednesday, September 17 2014
The Insert Statement in SQL: Overview After examining the core SQL statements used to create objects within relational database management systems, you should next learn how to add, edit, delete and select data within these same systems. SQL uses the Data Manipulation Language statements to accomplish these tasks. The first statement to learn is
SQL Training: Using SQL in Access 2013
Monday, June 23 2014
The SQL training “Mastering Introductory SQL Made Easy™ v.1.0” discusses SQL in Access 2013. Access 2013 is a RDBMS that creates self-contained databases and provides visual tools to allow users to make relational databases without the need for SQL. As such, there are few places to use SQL in Access.
- Published in Access 2013, Latest, Microsoft, Office 2013, SQL