Tag: t-sql

A Practical Use of the SQL COALESCE Function

Database development, Statements

This article talks about the practical use of the SQL COALESCE function regarding some professional...
Read More

Handling the NULL Values Effectively with the SQL COALESCE Function for Beginners

Database development, Statements, Tables

This article aims to help beginners understand the basics of the T-SQL COALESCE function and its application for handling NULL values....
Read More

Using CASE Expressions in SQL Server

Database development, Statements

Introduction CASE Expressions in SQL Server are used for the column values substitution to present the result sets in a particular fashion...
Read More

Your Ultimate Guide to SQL Join: INNER JOIN – Part 1

Database administration, Work with data

Inner join, outer join, cross join? What gives? It’s a valid question. I once saw a Visual Basic...
Read More

SQL Server Inner Join Basics with Examples

Database development, T-SQL, Tables

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...
Read More

Understanding Text Mining with SQL Example

Languages & Coding, T-SQL

The current article focuses on the conceptual understanding of Text Mining. It gives clear examples and teaches us to use the T-SQL script...
Read More

Filtering Data in T-SQL

Languages & Coding, T-SQL

Introduction In most scenarios when working with data, users do not require all the data in each...
Read More

Using Transaction ROLLBACK in SQL Server

Database administration, Statements, Transaction Log

Introduction Very recently, a colleague of mine came to me in desperation owning up that he had issued an update statement without a WHERE...
Read More

Analytic Functions in SQL Server

Code Management, Tools & technologies

Aggregate and Analytic functions in SQL Server operate on a set of rows. However, unlike such aggregate functions as sum, count and average...
Read More

Automate Database Test Restore in SQL Server

Automation, Database administration, Testing

This article talks about automating the database restoration process which is often done manually...
Read More
Close