PouchDB Replication Replication is a very important feature of PouchDB. It facilitates you to make a copy of a database. You can…
create database
-
-
MariaDB FROM Clause MariaDB FROM Clause is used to fetch data from a table. It is also used to join tables which…
-
DB2 Datatypes In DB2 Database tables, each column has its own data type depending on developer’s requirements. The data type is said…
-
SQL Server Show/List Databases It’s a common task to display or list all databases, listing tables of a particular database, and information…
-
SQL Server Window Functions We are all well-known for the regular aggregate function that performs calculations on the table and works with…
-
SQL Server String Functions A string function accepts a string value as an input and returns a string value regardless of the…
-
Stored Procedure in SQL Server A stored procedure is a group of one or more pre-compiled SQL statements into a logical unit.…
-
SQL Server STUFF() Function This article will describe a complete overview of the STUFF function in SQL Server. Most of the DBA…
-
SQL Server Substring SUBSTRING is a SQL Server built-in function that allows us to extract a specific substring from any given string…
-
SQL Server SUM() Function The SUM() function in SQL Server is a type of aggregate function. We use this function to calculate…