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...
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 more than happy to hire a new guy who...
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...
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 display the fifth most highly paid...
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...
Overview of DBCC SHRINKFILE Command
Running DBCC Shrink commands is quite a controversial issue across the SQL Server community. In this article, we will review details about...
Advanced SQL: CROSS APPLY and OUTER APPLY
In this article, we’ll look into the “APPLY” operator and its variations – CROSS APPLY...
