## SQL sqrt Function | Square Root of a Number

SQL sqrt is an inbuilt Math Function in SQL Server. It calculates the square root of an input number in SQL Server. In this article, we will discuss the SQL sqrt Function. Also, we will discuss a few examples of using it. Syntax SQRT (number) Parameters The function expects only one input. The number for… Read more SQL sqrt Function | Square Root of a Number

## PHP decbin Function | Convert Decimal To Binary String

PHP decbin is an inbuilt Math Function in PHP. It converts an input decimal integer into its corresponding binary representation string. You can convert a binary string to its corresponding decimal integer using PHP bindec Function. Syntax decbin (\$integer) Parameters The function accepts only one parameter. The decimal value for which you want to find… Read more PHP decbin Function | Convert Decimal To Binary String

## PHP bindec Function | Convert a Binary to Decimal

PHP bindec is an inbuilt Math Function in PHP. It converts an input binary string into its corresponding decimal representation. In this article, we will discuss the PHP bindec Function. You can use the PHP decbin Function to convert a decimal integer to it’s corresponding binary string. Syntax bindec (\$binaryString) Parameters The function accepts only… Read more PHP bindec Function | Convert a Binary to Decimal

## SQL abs Function | Absolute Value of an Integer

SQL abs is an inbuilt Math function in SQL Server. It returns the absolute (positive) value of a number. It is identical to modulus in mathematics. In this article, we will discuss the abs Function in SQL Server. Also, we will discuss examples of using it. Syntax ABS (number) Parameters The function expects only one… Read more SQL abs Function | Absolute Value of an Integer

## SQL UNION Operator | Combine Separate SQL Statements

The SQL UNION operator combines the result of two or more SQL SELECT queries and returns the combined result of the queries as a union. In this article, we will discuss the SQL Union Clause. Also, we will discuss a few examples of using it. Syntax SELECT column1, column2 … columnN FROM table1 UNION SELECT… Read more SQL UNION Operator | Combine Separate SQL Statements

## SQL RIGHT JOIN

SQL RIGHT JOIN statement returns all the records present in the right table and matched records from the left table. However, the result will contain null for the rows which are not present in the left table. In this article, we will discuss the SQL RIGHT JOIN Statement. Also, we will discuss a few examples… Read more SQL RIGHT JOIN

## SQL LEFT JOIN

SQL LEFT JOIN statement returns all the records present in the left table and matched records from the right table. However, the result will contain null for the rows which are not present in the right table. In this article, we will discuss the SQL LEFT JOIN Statement. Also, we will discuss a few examples… Read more SQL LEFT JOIN

## SQL INNER JOIN

SQL INNER JOIN statement selects data present in both (or more) tables according to the common field between them. It matches all the rows in table 1 with all the rows with table 2 for the JOIN condition and returns all the pair of rows which match the criteria. Therefore, a row from table 1… Read more SQL INNER JOIN

## PHP exit Function | Print a Message and Exit Script

PHP exit is a very useful and important inbuilt function in PHP. It prints a message and exits the current running script. Therefore, any code after the exit function will not be executed. Also, shutdown functions and object destructors are always executed even after the exit function. In this article, we will discuss the PHP… Read more PHP exit Function | Print a Message and Exit Script

## PHP die Function | Print a Message and Exit Script

PHP die is a very useful and important inbuilt function in PHP. It prints a message and exits the current running script. Therefore, any code after the die function will not be executed. Also, shutdown functions and object destructors are always executed even after the die function. In this article, we will discuss the PHP… Read more PHP die Function | Print a Message and Exit Script