In this blog, we will learn how to check if a particular column of a table is updated or not. If the column updates, the current record inserts into a trigger table using the trigger.

This blog explains the process of how to convert CSV values into row values and vice-versa, using in-built and custom SQL queries.

Sometimes, we may want to encrypt a SQL Server column data, such as a credit card number. In this blog, let's learn how we can encrypt and decrypt SQL Server column data in the database itself.

Here, I will be giving a brief introduction to Indexes in SQL Server and why we need the indexing.

Date of Birth can be used to calculate the age in years, months, and days.

In this blog, I will explain how to improve the performance of your SQL query. As a developer, we know any SQL query can be written in multiple ways but we should follow the best practices/techniqu...

In this blog, we will understand how we can find employees hired last month or year. We will understand DATEDIFF function in SQL server. The DATEDIFF function is used to calculate the difference b...

In this blog, we are going to learn about clauses in SQL Server. Clauses are used with table expressions and help in finding the result.

In this blog, we will understand how to join two or more SQL tables without using a foreign key. We will also get an overview of Join and Keys in SQL.

In this blog, we will understand the usage of ASCII function in SQL Server and find ASCII values of capital and small alphabets.

How to delete duplicate records from a SQL data table using CTE (common table expression). Specifies a temporary named result set, known as a common table expression (CTE).

Learn about know forensic analysis of SQL Log

This article demonstrates how to create and use a scalar function in the SQL Server database. In this blog, we won't go very far. We will perform only basic functions.

Database Logs are used for any modification/transaction on table production or during development from their Database Server.

Many times we come across null values within tables in SQL Server. Null values are the values with no data; that means the data is missing or unknown. In this article, initially we will understand ...

Here, we will discuss the full procedure to rebuild Master Database in SQL Server without unavailability of backup. Read the complete blog very carefully to get appropriate results.

In this blog, we will learn about aggregate function in SQL Server. An aggregate function is used to calculate the given values and returns a single value.

In this article we learn about Date and time functions in SQL Server.These functions are working on given date and time.These functions are SQL Pre defined functions.

In this blog. I will explain you how to find random record in SQL server. This is most common interview question. The CHECKSUM function returns the checksum value computed over a table row, or over...

In this post, we will learn how to calculate the time between two dates in years, months, and days format. There is a special function for getting a perfect year, month, and day count.