Tag: T-SQL
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...
TRUNCATE TABLE SQL server statement is used to delete all records from a table. It performs the same function as the DELETE operator, without the WHERE offer.Warning: when truncating a table,...
SQL operator SELECT TOP is used to extract records from one or more tables in a database and limit the number of records to be returned based on a fixed value or percentage.Tip: SELECT TOP is...
SQL operator SELECT LIMIT is used to extract records from one or more tables in the database and limit the number of records to be returned based on the limit value.Tip: SELECT LIMIT is not...
SQL Server operator ORDER BY is used to sort records in the SELECT query result set. Syntax for ORDER BY statement in SQL Sorting by one field:SELECT * FROM tab n WHERE condition ORDER BY...
SQL Server the most popular database management systems (DBMS) in the world. This DBMS is suitable for a variety of projects: from small applications to large highly loaded projects.SQL...
SQL RTRIM - The RTRIM function can remove all specified characters from the right side of the string in Oracle/PLSQL. Syntax of the Oracle/PLSQL RTRIM function RTRIM( string_d, [ trim_string_d...
IDENTITY SQL - The table property in Microsoft SQL Server is IDENTITY_INSERT. Using this property, we can insert an explicit value into the autoincrement column with IDENTITY that was previously...
SQL IIF function of T-SQL language, which is designed to simplify the writing of conditional constructions using the well-known expression CASE or operators IF...ELSE...THEN.IIF is a logical...
The ISNULL SQL Server function checks the value of some expression. If it is NULL, the function returns a value which is passed as the second parameter: ISNULL(expression, value). Syntax of...
AVG function (Average) in SQL Server (Transact-SQL) - AVG function returns the arithmetic mean for all found records. Arithmetic mean of a group of numbers is their sum divided by their...
INSERT INTO - is a T-SQL instruction designed to add data to a table, i.e. create new records. This instruction can be used both for adding one line to the table and for mass inserting data....
The CREATE TABLE instruction in SQL Server creates a new database table with all relevant columns of the required data type. The following is the basic form of the CREATE TABLE manual:CREATE...
MERGE SQL - In Transact-SQL language in one row with such operations as INSERT (insert), UPDATE (update), DELETE (delete) is the operation MERGE (merge), which in some cases may be useful, but...
The INSERT SQL statement is used to insert one or more records into a table. There are two syntaxes for the INSERT statement depending on whether you are inserting one record or more...
In SQL Server (Transact-SQL), the CHARINDEX function returns the substring location in a string. The search is case insensitive.Syntax of the CHARINDEX function in SQL Server...