Merge Statement in SQL Server

Merge Statement in SQL Server In this post I will explain all about Merge Statement in SQL Server. So let’s start. Merge Statement in SQL Server Microsoft introduced the Merge statement into SQL Server 2008 to perform the INSERT, UPDATE and DELETE statements into a single statement. The SQL Merge…

0 Comments
Subqueries in SQL Server
Sub queries in SQL Server Part - 12

Subqueries in SQL Server

Subqueries in SQL Server In this post I will explain all about Subqueries in SQL Server. So let’s start. Subqueries in SQL Server WHAT IS SUBQUERIES IN SQL SERVER? A sub-query is a normal T-SQL query that is nested inside another query – using parentheses – created when we have…

0 Comments

Normalization in SQL Server

Normalization in SQL Server In this post I will explain all about Normalization in SQL Server, although this part is quite short. So let’s start. Normalization in SQL Server NORMALIZATION Normalization is the technique of designing the database with the least redundancy and duplicity of data.  or A method to…

0 Comments
Set Operators in SQL
Set Operators in SQL Server Part - 10

Set Operators in SQL

Set Operators in SQL In this post I will explain about Set Operators in SQL Server, although this part is quite short. So let’s start. Set Operators in SQL Set Operators in SQL: There are 4 types of set operators in SQL – Union – Distinct records in ascending orderUnion…

0 Comments
Microsoft SQL Server Joins
Microsoft SQL Server Joins Part - 9

Microsoft SQL Server Joins

Microsoft SQL Server Joins In this post I will explain about Microsoft SQL Server Joins, although this part is quite so long. So let’s start. Microsoft SQL Server Joins MICROSOFT SQL SERVER JOINS CLAUSE INTRODUCTION The JOIN keyword produces results based on a relationship between two or more tables. There…

0 Comments
Microsoft SQL Server Functions
Microsoft SQL Server Functions Part - 8

Microsoft SQL Server Functions

Microsoft SQL Server Functions In this post, I will explain about Microsoft SQL Server Functions, although this part is quite so long. So let’s start. Microsoft SQL Server Functions What is Microsoft SQL Server Functions built-in Function? There are two types of functions in SQL Server are mentioned below –…

0 Comments
Operators, ERD and T-SQL Statements in SQL Server
Operators, ERD and T-SQL Statements in SQL Server Part - 7

Operators, ERD and T-SQL Statements in SQL Server

Operators, ERD and T-SQL Statements in SQL Server In this post I will explain about Operators, ERD, and Basic T-SQL Statements in SQL Server. So let’s start. Operators, ERD and T-SQL Statements in SQL Server What are Operators in Microsoft SQL Server? All the operators are a keyword that is…

0 Comments
Data Types and Wild Card Characters in Microsoft SQL Server
Data Types and Wild Card Characters in Microsoft SQL Server Part - 6

Data Types and Wild Card Characters in Microsoft SQL Server

Data Types and Wild Card Characters in Microsoft SQL Server Image Credits: itprotoday.com In this post I will explain Data Types and Wild Card Characters in Microsoft SQL Server. So let’s start. Data Types and Wild Card Characters in Microsoft SQL Server What are the SQL Server Data Types? The…

0 Comments
Data Integrity and Key Constraints in Microsoft SQL Server
Data Integrity and Key Constraints in Microsoft SQL Server Part - 5

Data Integrity and Key Constraints in Microsoft SQL Server

Data Integrity and Key Constraints in Microsoft SQL Server Image Credits: Microsoft SQL Server 2012 Overview This post I will explain Data Integrity and Key Constraints in the Microsoft SQL Server. So let’s start. Data Integrity and Key Constraints in Microsoft SQL Server What is Data Integrity? Data integrity means…

0 Comments
Microsoft SQL Server Language
Microsoft SQL Server Language

Microsoft SQL Server Language

Microsoft SQL Server Language Image Credits: Microsoft SQL Server 2012 Now we will learn some basic things about Microsoft SQL server language. So let’s start. Microsoft SQL Server Language Basically there are four (4) types of SQL language mentioned below – DDL(Data Definition Language) –  CREATE, ALTER, DROP, TRUNCATEDML(Data Manipulation…

0 Comments