Understanding of triggers in SQL Server. Overview of trigger groups, magic tables, DML triggers with the use case, and real examples.A SQL Server trigger is like a stored procedure that executes ...

This tutorial will show you the concept of IIF Function In SQL Server.

In this article, you will learn about Table Scan, Index Scan, and Index Seek.

In this article we are going to explore how to create custom CLR assembly and how to access it in the SQL Server.

This tutorial will show you the difference between the HAVING and WHERE Clause in SQL Server.

In this blog, you will learn how to export Blob(BINARY or VARBINARY) From SQL Server Table and save it as a file.

The idea of this blog is to share the leanings from the incidents which I have faced during my 8 years of experience with SQL Server which will help developers to write optimized SQL Query with les...

A SQL cursor is a database object that retrieves data from result sets one row at a time.The cursor in SQL can be used when the data needs to be updated row by row.

In this blog, we will discuss how to find the highest salary, the second highest salary and N number of highest salaries with different examples.

In this article, I have described various ways to handle NULL in SQL Server.

In this article I'll discuss how to put a SQL database into a Recovery Pending state.

In this blog we will learn how to take backup of database in SQL Server Express edition.

Get Table All Columns Schema Information in One Click In this article, I will show how we can get table columns information like ColumnName, DataType, DataType Length, is mandatory, and column brie...

In this article, you will learn about the SQL SERVER MERGE statement.

A SQL trigger is a database object just like a stored procedure or we can say it is a special kind of Stored Procedure that automatically fires when an event occurs in a database. Learn what is a t...

In this blog, you will learn how to reset an Identity Column Value in SQL Server.

Here is a list of the most popular MSSQL interview questions and answers explained. These SQL interview questions are for both beginners and professional MSSQL developers.

SQL contains string is used to check if a string contains a substring in SQL Server or not.

In this article, you will learn about the most important SQL Commands.

This tutorial will show you various methods to generate scripts for database objects in SQL Server 2019.

If you’re a developer, irrespective of the platform, you would have to work with Databases. Creating SQL statements for tables is quite often a monotonous job and it gets hectic especially with dea...

In this article we will explore the usage of Exists and Not Exists in SQL Server

In this article, we will see how to create a SQL Server Database backup. Database backup using SQL Server Management Studio, SQL Server provides a large number of options to create backups. We will...

In this article, you will learn how to convert the UTC Datetime to any timezone using SQL.