SQL – BACKUP DATABASE Keywords
The BACKUP DATABASE keywords are used in SQL Server to create a full back up of an existing SQL database.
SQL – CHECK Keyword
The CHECK keyword is a constraint that limits the value that can be placed in a column.
SQL – CONSTRAINT Keyword
The CONSTRAINT keyword is used to create or delete a constraint from an existing table.
SQL – DEFAULT Keyword
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 – DROP Keyword
The DROP keyword is used to delete existing columns, constraints, databases, indexes, tables, and views.
SQL – FOREIGN KEY Keywords
The FOREIGN KEY keywords are a key (a field or fields in one table that refers to the PRIMARY KEY in another table) used to link two tables together.
SQL – INDEX Keyword
Indexes are used to speed up the retrieval of data (searches/queries) from the database.
SQL – PRIMARY KEY Keywords
The PRIMARY KEY keywords uniquely identifies each record in a table, which can have only one primary key consisting of a single field or multiple fields.
SQL – SQL Server ABS() Function
The SQL Server ABS() function returns the absolute value of a number.
SQL – SQL Server ACOS() Function
The SQL Server ACOS() function returns the arc cosine of a specified number between -1 and 1.
SQL – SQL Server ASCII() Function
The SQL Server ASCII() function returns the ASCII value for the specified character.
SQL – SQL Server ASIN() Function
The SQL Server ASIN() function returns the arc sine of a specified number between -1 and 1.
SQL – SQL Server ATAN() Function
The SQL Server ATAN() function returns the arc tangent of a number.
SQL – SQL Server ATN2() Function
The SQL Server ATN2() function returns the arc tangent of two numbers.
SQL – SQL Server AVG() Function
The SQL Server AVG() function returns the average value of an expression (NULL values are ignored).
SQL – SQL Server CAST() Function
The SQL Server CAST() function converts a value of any type into a specified datatype.
SQL – SQL Server CEILING() Function
The SQL Server CEILING() function returns the smallest integer value that is larger than or equal to a number.