SQL Server Bulk Insert – Part 1
According to Wikipedia, ”A Bulk insert is a process or method provided by a database...
SQL Server CRUD Operations
In database programming, there are four fundamental operations: create, read, update, and delete – CRUD operations. They are the first...
Dealing with NULLs in SQL Server
What is NULL? NULL or the NULL marker is the way we represent an unknown value in SQL, by SQL I am referring to the standard Structured...
Introduction to SQL Server Identity
In this article, we will explore the basics and details of the SQL Server IDENTITY property and the...
Basics of Running T-SQL Statements from Command Line using SQLCMD
This article is about developing a basic understanding of sqlcmd utility to run T-SQL commands directly from the command prompt without the...
How to Write T-SQL Queries Like a Pro
The skills of writing different types of SQL Server queries require you to have good knowledge in the SQL Server T-SQL language. T-SQL...
Multiple Ways to Delete Duplicates from SQL Tables
Overview This article discusses two different approaches available to remove duplicate rows from...
Using DATEADD, DATEDIFF and DATEPART T-SQL Functions in Simple Terms
This article focuses on developing a basic understanding of how to use one of the most common Transact-SQL date functions: DATEADD,...
MERGE: Updating Source and Target Tables Located on Separate Servers
What is the MERGE statement? Using the MERGE statement, we can change data in a target table based on data in a source table. Using it, we...
How to create Snapshot Replication
The concept of snapshot replication is simple. It generates and distributes the snapshot of schema...
