Tag: T-SQL

SQL condition OR is used to check several conditions in SELECT, INSERT, UPDATE or DELETE. Any of the conditions must be met to select a record. Syntax for SQL condition OR WHERE cond1 OR...

SQL condition AND (also known as SQL AND operator) is used to check two or more conditions in a SELECT, INSERT, UPDATE or DELETE operator. All conditions must be met to select a record. Syntax...

SQL comparison operators are used in the WHERE sentence to determine which records to select. Here is a list of comparison statements that you can use in SQL:Comparator...

SQL Indexes - The index is a method of performance tuning that allows for much faster retrieval of records. The index creates a record for each value that appears in the indexed columns. Each...

SQL Primary Keys - In SQL, the primary key is a single field or a combination of several fields that uniquely define a record. None of the fields that are part of the primary key should contain...

SQL VIEW is essentially a virtualized table that does not exist in nature. This table is created by an SQL statement that combines one or more tables. Create SQL VIEW Syntax for CREATE VIEW in...

SQL local temporary tables - unique in modules and built-in SQL programs in SQL sessions. Syntax for DECLARE LOCAL TEMPORARY TABLE in SQL DECLARE LOCAL TEMPORARY TABLE tab_name ( column_1...

SQL GLOBAL TABLES are tables that are created separately in SQL sessions. Syntax for CREATE GLOBAL TEMPORARY TABLE in SQL CREATE GLOBAL TEMPORARY TABLE tab_name ( col1 datatype_1 [ NULL | NOT...

DROP TABLE SQL statement allows you to remove a table from an SQL database. Syntax for DROP TABLE statement in SQL DROP TABLE tab_name;where:tab_name - Name of the table to delete...

HAVING SQL operator is used in combination with GROUP BY operator to limit groups of returned strings only to those whose condition is TRUE. Syntax of the HAVING operator in SQL SELECT expr1,2,...

WHERE SQL operator is used to filter results and apply conditions in SELECT, INSERT, UPDATE or DELETE. Syntax for WHERE statement in SQL WHERE conds;where:Conds - to be met for...

FROM SQL statement is used to enumerate tables and any associations required for SQL statement. Syntax of FROM statement in SQL FROM tab1 [ { INNER JOIN | LEFT [OUTER] JOIN | RIGHT [OUTER]...

The DISTINCT SQL operator is used to remove duplicates from the resulting SELECT operator set. Syntax for DISTINCT statement in SQL SELECT DISTINCT exprs FROM tabs [WHERE...

The EXCEPT SQL statement is used to return all lines in the first SELECT statement that are not returned by the second SELECT statement. Each SELECT operator will define a data set. EXCEPT will...

The MINUS SQL operator is used to return all lines in the first SELECT operator, which are not returned by the second SELECT operator. Each SELECT operator will define the data set. The MINUS...

INTERSECT SQL Server statement - The statement is used to return 2 or more SELECT statements. However, it returns only the strings selected by all queries or data sets. If a record exists in one...