Tag: sqls ms

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...

SQLS*Plus for SQL Server Data Output - HTML Data Output, CSV Data Output, JSON Data Output, Vertical Data Output, and Column Autoformatting. HTML Data Output Use “set markup html on|off”...

SQLS*Plus: Passing parameters as script arguments You can skip the hints for values that are associated with the substitution of variables by giving them values of parameters in the script, typing...

List of Commands:   Command    Usage     Description  & &<variable name>   Use substitution...

1) Activate Quick Edit Mode2) Set proper layout attributesa) Set Screen Buffer Size to 122 and 9999 correspondinglyb) Set Window Buffer Size to 122 and 55...

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,...

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...

UNION ALL SQL Server operator is used to combine the resulting sets of 2 or more SELECT operators. It does not remove repeating rows between different SELECT operators (all rows are...