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...
Essentials and usage of NOLOCK hint in SQL Server
The main idea of the SQL Server locking mechanism is that it controls the consistency of transactions. According to this principle, if a...
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...
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...
Configuring Database Mail in SQL Server
SQL Server Database Mail has been introduced in SQL Server 2005. Database Mail is a component that...
Passing Data table as Parameter to Stored Procedures
Real-world database applications need to make multiple requests from the front end to the database in order to carry out all sorts of...
Similarities and Differences among RANK, DENSE_RANK and ROW_NUMBER Functions
The RANK, DENSE_RANK and ROW_NUMBER functions are used to retrieve an increasing integer value. They start with a value based on the...
SQL Server IntelliSense and Autocomplete
Starting from SQL Server 2008, Microsoft introduced a new feature in the SQL Server Management...
