AppDividend
Latest Code Tutorials
Browsing Category

SQL

SQL is a standard language for storing, manipulating and retrieving data in databases.

Our SQL tutorial will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems.

SQL SYSDATETIMEOFFSET: Complete Guide

SQL SYSDATETIMEOFFSET() returns a value that represents the current system date and time, including the computer's time zone on which the SQL Server instance is running. The datatype returned is of DATETIMEOFFSET (7) type. SQL…

SQL RTRIM() Function: Complete Guide

The RTRIM is one of the SQL String Function used to remove the empty spaces from the Right-hand side of the character expression. SQL RTRIM Function SQL RTRIM() is a built-in function used to return the character expression after…

SQL Operators: The Complete Guide

An operator in SQL is the reserved word or a character used primarily in the SQL statement's WHERE clause to operate (s), such as comparisons and arithmetic operations. These reserved characters or words are known as the operators in SQL.…

SQL SOUNDEX() Function: Complete Guide

SQL SOUNDEX() converts the String to the four-character code based on how the String sounds when spoken. SQL SOUNDEX() SQL SOUNDEX() is a built-in function that accepts the string and returns the phonetic expression, i.e., converts it…

SQL Right() Function: Complete Guide

 SQL RIGHT() function extracts the given number of characters from the right side of the specified character string. So, if you are searching for a substring of the right part of the main string, you can use the RIGHT() function. It accepts…

SQL SQRT() Function: The Complete Guide

The SQRT() in the SQL function returns the square root of a number. SQL SQRT() SQL SQRT() is a built-in function used to return the square value of the specified number. The SQRT() returns the square root of a given value in the…

SQL CHOOSE() Function: Complete Guide

SQL CHOOSE() function introduced in SQL Server 2012. This SQL Choose function returns the item at the specified index from the list of items. SQL CHOOSE SQL CHOOSE() is a built-in function used to return an item from the list of items…

SQL ISNUMERIC() Function: Complete Guide

SQL ISNUMERIC function tests whether the expression is numeric. The ISNUMERIC() function accepts an expression and returns 1 if it is a valid numeric type; otherwise, it returns 0. SQL ISNUMERIC() SQL ISNUMERIC() is a built-in function…

SQL ISNULL() Function: Complete Guide

The ISNULL() function returns the particular value if the expression is NULL. If the expression is NOT NULL, then ISNULL() function returns the expression. SQL ISNULL() SQL ISNULL() is a built-in function used to replace the NULL values…

SQL CAST() Function: Complete Guide

The CAST() function converts a value (of any type) into a specified datatype. SQL CAST SQL CAST() is a built-in function that is used for converting an expression from one data type to another data type. If the conversion takes place, a…