SQL – ADD Keyword
January 19, 2023
The ADD keyword is used to add columns or constraints to an existing table.
SQL – ALL Keyword
December 29, 2022
The ALL keyword returns true if all of the subquery conditions are met.
SQL – ALTER Keyword
January 19, 2023
The ALTER keyword adds, deletes, or modifies columns in a table. It can also add and delete various constraints in a table.
SQL – AND Keyword
January 19, 2023
The AND keyword is used with the WHERE keyword to only include rows where both conditions is true.
SQL – ANY Keyword
December 29, 2022
The ANY keyword returns true if any of the subquery conditions are met.
SQL – AS Keyword
December 30, 2022
The AS keyword is used to output a column or table with a temporary alias for the duration of the query. Nothing in the database itself is altered.
SQL – ASC Keyword
December 30, 2022
The ASC keyword is used to sort the returned data in ascending order (A – Z).
SQL – BACKUP DATABASE Keywords
January 4, 2023
The BACKUP DATABASE keywords are used in SQL Server to create a full back up of an existing SQL database.
SQL – BETWEEN Keyword
December 31, 2022
The BETWEEN keyword is used to select values (numbers, text, or dates) within a given range (inclusively).
SQL – CASE Keyword
January 1, 2023
The CASE keyword is used is to create different output based on various conditions.
SQL – CHECK Keyword
January 19, 2023
The CHECK keyword is a constraint that limits the value that can be placed in a column.
SQL – COLUMN Keyword
January 19, 2023
The COLUMN keyword is used to change the data type of a column or delete a column in a table.
SQL – CONSTRAINT Keyword
January 5, 2023
The CONSTRAINT keyword is used to create or delete a constraint from an existing table.
SQL – CREATE Keyword
June 14, 2023
The CREATE keyword is used to create new databases, indexes, procedures, tables, and views.
SQL – DATABASE Keyword
January 4, 2023
The DATABASE keyword is used to create a new SQL database or delete an existing SQL database.
SQL – DEFAULT Keyword
January 19, 2023
The DEFAULT keyword provides a default value for a column that will be added to all new records if no other value is specified.
SQL – DELETE Keyword
January 4, 2023
The DELETE keyword is used to delete existing records in a table.
SQL – DESC Keyword
December 30, 2022
The DESC keyword is used to sort the returned data in descending order (Z – A).
SQL – DISTINCT Keyword
January 7, 2023
The DISTINCT keyword returns only different values (no two values the same) in the result set.
SQL – DROP Keyword
February 6, 2023
HTML
CSS
JavaScript
jQuery
PHP
SQL
WordPress
HTML
CSS
JavaScript
jQuery
PHP
SQL
WordPress
Why 1SMARTchicken?
This site was built and is maintained to benefit my autistic son.
See More →
See More →
Thanks for your support!
Books
All are affiliate links. Thank you for your support!
