Common Table Expressions(CTEs)
Sql server 2016

Common Table Expressions (CTEs)

In this post we will learn about Common Table Expressions(CTEs) which is one of the table expression. It is similar to derived table in scope and naming requirements. Unlike derived
Derived tables
Sql server 2016

Derived Tables

In this post we will learn about derived table which is one of the table expression. It is a form of subquery that returns an entire table as a result.
Table Expressions
Sql server 2016

Table Expressions

In this post we will discuss about table expressions. Table expressions are named queries and they are not physically materialized anywhere—they are virtual. T-SQL Support four forms of table expressions: –
70-762 Developing Databases
Sql server 2016

MCSA 70-762 Developing Databases Review | Learn 70-762 Developing Databases

70-762 Developing Databases exam is intended for database professionals who build and implement databases across organizations and maintain high levels of data availability. Their responsibilities include creating database files, data
Subqueries
Sql server 2016

Subqueries

Subqueries In this post we will discuss Subqueries in SQL Server. Subqueries are nested queries means query within Query.it returns result of inner query to outer query. In SQL Server
APPLY operator
Sql server 2016

OUTER APPLY Operator

OUTER APPLY Operator In this post we will discuss OUTER APPLY Operator in SQL Server 2016. The APPLY Operator combines the advantages of both joins and subqueries. The OUTER apply
APPLY operator
Sql server 2016

SQL: APPLY Operator

SQL: APPLY Operator In this post we will discuss APPLY operator in SQL Server 2016. APPLY operator is powerful operator that applies the right table expression to each row from
String functions in SQL
Sql server 2016

SQL:String Functions

String Functions In last post we discuss about UPPER(), LOWER(), REVERSE(), FORMATE(), REPLACE() ,CHARINDEX() string functions. And today we discuss remaining string functions. In this entire post for examples we
Amazon Products

Honor 7x

Honor 7X Today we will discuss about honor 7x review. 15.06 centimeters (5.93-inch) capacitive touchscreen, FHD+ 18:9 display with 1080 x 2160 pixels resolution and 407 ppi pixel density 16MP
Inheritance
Kotlin

Kotlin: Inheritance

Inheritance In this post we will discuss Inheritance in kotlin with example. Inheritance provides the reusability of the previously defined functions. The previously defined class is called super(base, parent) class
Top