T-SQL SET Operators Part 2: INTERSECT and EXCEPT
In my previous article, I explained the basics of set operators, their types, and prerequisites for...
Advanced SQL: Variations and Different Use cases of T-SQL Insert Statement
In my previous article, I demonstrated: Insert the output of the table-valued function in the SQL table. Insert the output of the...
T-SQL SET Operators Part 1: UNION and UNION ALL
In SQL Server, we can combine the same type of data from multiple tables using SET operators. After combining multiple SQL statements, it...
Advanced SQL: CROSS APPLY and OUTER APPLY
In this article, we’ll look into the “APPLY” operator and its variations – CROSS APPLY...
Advanced SQL: Insert output of the parameterized table-valued function in SQL table
In this article, I am going to demonstrate the following: How to insert the output of a table-valued function in a SQL table. How to insert...
Auto-Email System to Send Database Summary Report
Database monitoring is the most essential job of any database administrator. Big organizations and companies have multiple database servers...
SQL Server Database Replication
Database replication is the technology to distribute data from the primary server to secondary...
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 and data of articles, appeared at a...
How to create Transactional Replication
In this article, I am going to demonstrate how to create transactional replication. Transactional...
