For capturing the changes of DML statements we must be familiar with the Merge statement and Output clause in SQL Server. I am giving a general overview of these statements.

Here the use of fishhook relation to represent tree structures is explained through a detailed example in T-SQL.

In this article you will learn how to capture configuration information in SQL Server using sys.configurations.

This article shows how to show a date and time in a formatted manner as per our business requirements.

In this article you will learn how to use SQL SERVER Memory Management.

Learn how to Convert SQL Server Data to JSON using JSON PATH clause.

In this article, we will learn some of the important facts about MySQL Server.

In this article we will see what a SQL Server Integration Services (SSIS) is; basic on why SSIS is used for, how to create a SSIS Package and how to debug the same.

OpenJSON is a SQL function. That is used to convert a JSON text and return a key and value as a row and column format. Meaning it helps to make JSON queryable.

This article will show the differences among scope_identity (), @@identity and ident_current.

In this article, I am explaining how to get the last inserted identity value of an auto-increment column of database tables using SQL Server variable (@@IDENITY) and functions (SCOPE_IDENTITY() and...

When we try to change an existing table in SQL Server 2008, you might receive a Save (Not Permitted Dialog) box pop-up. This article explains the error and what to do about it.

SQL Server Analysis Services (SSAS) provides a unified and integrated view of all your business data as the foundation for all of your traditional reporting, online analytical processing (OLAP) ana...

This article describes the use of different query and operator of SQL.

This article is an introduction to the Structured Query Language (SQL) and its most common commands.

Here you will see how to use SQL Executer. The article is written for beginners, the methods to communicate with database are kept simple.

In this article, we are going to see how to save your custom queries as a template and reuse the queries instead of saving as a file.

The very first task of creating an analysis project is to create a data source.

In this article, I would like to show the functions DATEADD, EMONTH, TODATETIMEOFFSET in SQL Server.

In this article you will learn DataTableAdapter Design Technique using DataSet.