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
PHP substr_count Function | Count of Occurrences of Substring
PHP substr_count is an inbuilt String Function in PHP. It calculates the number of occurrences of a substring in another string. Also, the function provides an option to search the substring within a range in the string. In this article, we will discuss the PHP substr_count Function. Also, we will discuss a few examples of… Read more PHP substr_count Function | Count of Occurrences of Substring
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