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...
Your Ultimate Guide to SQL Join: INNER JOIN – Part 1
Inner join, outer join, cross join? What gives? It’s a valid question. I once saw a Visual Basic...
SQL Server Inner Join Basics with Examples
Introduction T-SQL allows us to combine records from more than one table and return them as a single result set. This is achieved through...
Understanding Text Mining with SQL Example
The current article focuses on the conceptual understanding of Text Mining. It gives clear examples and teaches us to use the T-SQL script...
Filtering Data in T-SQL
Introduction In most scenarios when working with data, users do not require all the data in each...
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...
Analytic Functions in SQL Server
Aggregate and Analytic functions in SQL Server operate on a set of rows. However, unlike such aggregate functions as sum, count and average...
Automate Database Test Restore in SQL Server
This article talks about automating the database restoration process which is often done manually...
