SQL Server Triggers – Part 2 DDL & LOGON Triggers
In SQL Server, triggers are database objects which will get executed whenever a triggering event...
SQL Server Triggers: DML Triggers
In SQL Server, triggers are database objects which get executed whenever a triggering event happens on the database or server. Triggers...
Drop Temp Table in SQL Server and PostgreSQL
This article explains different ways to drop the temp table in SQL Server and PostgreSQL. As the name suggests, temporary tables are used...
What is SQL Server? (Definition, Versions, Editions)
Excited? That’s how it feels to learn a new skill on your first day. It can also feel a bit...
The Easy and Practical SQL Server Tutorial for Beginners
Introduction to Our SQL Server Tutorial for Beginners Hello, budding SQL Server enthusiast! CodingSight would like to focus on you, the...
How to Use SQL Server T-SQL Function SUM: 5 Use Cases
The T-SQL SUM function is one of the fundamental functions. Its purpose is to calculate the sum of all values in the specified column –...
SQL Server Resumable Index: Is it good for you?
SQL 2017 introduced the ability to pause and resume index rebuild operations during database...
SQL SELECT DISTINCT: Performance Best Practices
Is SQL DISTINCT good (or bad) when you need to remove duplicates in results? Some say it’s good and add DISTINCT when...
SQL OR Statement: The Basics
Now and then, you need to create a complex SQL query using multiple statements together. While these query types can be tedious to create,...
How to Use SQL SUM Function
SQL is a powerful and widely-used programming language for data storage, retrieval, and...