A Practical Use of the SQL COALESCE Function
This article talks about the practical use of the SQL COALESCE function regarding some professional...
Handling the NULL Values Effectively with the SQL COALESCE Function for Beginners
This article aims to help beginners understand the basics of the T-SQL COALESCE function and its application for handling NULL values....
Using CASE Expressions in SQL Server
Introduction CASE Expressions in SQL Server are used for the column values substitution to present the result sets in a particular fashion...
Top Answers to 5 Burning Questions on COALESCE Function in SQL Server
How cool is COALESCE function in SQL? It’s cool enough to be so important to me. And I’ll be...
The Easy Guide on How to Use Subqueries in SQL Server
Do you use SQL subqueries or avoid using them? Let’s say the chief credit and collections officer asks you to list down the names of...
Using Transaction ROLLBACK in SQL Server
Introduction Very recently, a colleague of mine came to me in desperation owning up that he had issued an update statement without a WHERE...
Ranking Functions in SQL Server
Suppose you are designing an SQL Server database application for a company’s CEO and you have to...
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 their use. I also talked about UNION...
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...
Overview of DBCC SHRINKFILE Command
Running DBCC Shrink commands is quite a controversial issue across the SQL Server community. In...
