Posts in Category: sql server article

Joins in Sql Server

Introduction

This is an article about joins in sql server . The article covers all aspects of joins using proper examples and Venn diagrams.

What is meant by joins in SQL server ?

Joins are the commands used to combine data from two or more tables based on relation between them. The relation between

Read More

How to Delete Duplicate Rows in Sql Server

Overview

Article will cover some best practices on how to delete duplicate rows in sql server.

We’ll be using a student table. Query for the table creation

(more…)

Read More