Sql Server Article Archives

Sql Server Article Archives - Dotnet Mob

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

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

CREATE TABLE tbl_Student
(
rollNumber INT,
studentName VARCHAR(MAX), 
address VARCHAR(MAX) 
)

CREATE TABLE tbl_Student

(

rollNumber INT,

studentName VARCHAR(MAX),

address VARCHAR(MAX)

)

(more…)

Introduction

This article is about comparing delete Vs truncate in SQL server, It is one of the most discussed topic on all SQL server forums, So there is no point in just discussing their basic difference, this article

Posts in Category: sql server article

Joins in Sql Server

Introduction

What is meant by joins in SQL server ?

How to Delete Duplicate Rows in Sql Server

Overview

Delete Vs Truncate in SQL Server

Introduction

Dotnet Mob

Get more stuff like this
in your inbox