Tag: sql

SQL Server Bulk Insert – Part 1

Database administration

According to Wikipedia, ”A Bulk insert is a process or method provided by a database...
Read More

SQL Server CRUD Operations

Statements

In database programming, there are four fundamental operations: create, read, update, and delete – CRUD operations. They are the first...
Read More

Dealing with NULLs in SQL Server

Database administration, Work with data

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...
Read More

Introduction to SQL Server Identity

Database development, Tables

In this article, we will explore the basics and details of the SQL Server IDENTITY property and the...
Read More

Basics of Running T-SQL Statements from Command Line using SQLCMD

T-SQL, Tools & technologies, Utilities & Extensions

This article is about developing a basic understanding of sqlcmd utility to run T-SQL commands directly from the command prompt without the...
Read More

How to Write T-SQL Queries Like a Pro

Languages & Coding, T-SQL

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...
Read More

Multiple Ways to Delete Duplicates from SQL Tables

Database development, Tables

Overview This article discusses two different approaches available to remove duplicate rows from...
Read More

Using DATEADD, DATEDIFF and DATEPART T-SQL Functions in Simple Terms

Database development, Statements • 11 Comments

This article focuses on developing a basic understanding of how to use one of the most common Transact-SQL date functions: DATEADD,...
Read More

MERGE: Updating Source and Target Tables Located on Separate Servers

Database development, Statements, Tables

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...
Read More

How to create Snapshot Replication

Database administration, Database Optimization & Structure

The concept of snapshot replication is simple. It generates and distributes the snapshot of schema...
Read More
Close