While loop: In SQL SERVER, while loop can be used in similar manner as any other programming language. A while loop will check the condition first and then exec
Identity column of a table is a column whose value increases automatically. The value in an identity column is created by the server. A user generally cannot in
There are situations when user want to change some portion of the data inserted. The reason may be because of the human error or the change in data. For this pu
There are two CREATE statements available in SQL: CREATE DATABASE CREATE TABLE CREATE DATABASE A Database is defined as a structured set of data. So, in SQL the
Aliases are the temporary names given to table or column for the purpose of a particular SQL query. It is used when name of column or table is used other than t
Division is typically required when you want to find out entities that are interacting with all entities of a set of different type entities. The division opera
SQL injection is a technique used to exploit user data through web page inputs by injecting SQL commands as statements. Basically, these statements can be used
Mathematical functions are present in SQL server which can be used to perform mathematical calculations. Some commonly used mathematical functions are given bel
LISTAGG function in DBMS is used to aggregate strings from data in columns in a database table. It makes it very easy to concatenate strings. It is similar to c
Constraints are the rules that we can apply on the type of data in a table. That is, we can specify the limit on the type of data that can be stored in a partic
Like in other programming languages, SQL also has certain datatypes available. A brief idea of all the datatypes are discussed below. 1. Binary Datatypes : T
As is any programming languages comments matter a lot in SQL also. In this set we will learn about writing comments in any SQL snippet. Comments can be written
Views in SQL are kind of virtual tables. A view also has rows and columns as they are in a real table in the database. We can create a view by selecting fields
The Common Table Expressions (CTE) were introduced into standard SQL in order to simplify various classes of SQL Queries for which a derived table was just unsu
Sequence is a set of integers 1, 2, 3, … that are generated and supported by some database systems to produce unique values on demand. A sequence is a user de
Query Processing includes translations on high level Queries into low level expressions that can be used at physical level of file system, query optimization an
A role is created to ease setup and maintenance of the security model. It is a named group of related privileges that can be granted to the user. When there are
The SQL WITH clause was introduced by Oracle in the Oracle 9i release 2 database. The SQL WITH clause allows you to give a sub-query block a name (a process als
What are Transactions? Transactions group a set of tasks into a single execution unit. Each transaction begins with a specific task and ends when all the tasks
In this article, we will see how to create, delete and uses of the INDEX in the database. An index is a schema object. It is used by the server to speed up the
SQL | ALL and ANY SOME operator evaluates the condition between the outer and inner tables and evaluates to true if the final result returns any one row. If not
Sometimes we may require tuples from the database which match certain patterns. For example, we may wish to retrieve all columns where the tuples start with the
The EXISTS condition in SQL is used to check whether the result of a correlated nested query is empty (contains no tuples) or not. The result of EXISTS is a boo
PL/SQL is a block-structured language that enables developers to combine the power of SQL with procedural statements. A stored procedure in PL/SQL is nothing bu
SQL(Structured Query Language) SQL stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Stand
