In this blog, we are trying to find in how many ways, we can find foreign key in SQL Server.

In this tutorial, I will explain how to pass the output parameter to a stored procedure in MS SQL Server.

SQL Server: Get the default path of data and log files via SERVERPROPERTY

In this blog, we will see how to Get the installed product edition using "SERVERPTOPERTY".

SQL Server: Get the Collation Details using SERVERPROPERTY

SQL Server: Check if the Server is in single-user mode using ServerProperty

Check the Advanced Analytics status using SERVERPROPERTY In SQL Server 2017/2016

Check if the failover cluster is configured or not using SERVERPROPERTY In SQL Server.

Check the integrated security mode using SERVERPROPERTY in SQL Server

Let's learn how to check if the "Always On" Availability of Groups is enabled or disabled using SERVERPROPERTY in SQL Server.

Check the "Always On" availability groups manager status using SERVERPROPERTY in SQL Server.

Check if the full-text and semantic indexing components are installed or not using SERVERPROPERTY In SQL Server

Today, we will learn how to update a Table using Join In SQL Server.

This blog will help users update a record while keeping the existing record value if it exists.

Count the number of rows in table within a milisecond with more than 28 lakh records.

Get the computer name on which the SQL server instance is running via "ServerProperty"

Get the full SQL Server instance name via "ServerProperty". In this blog, we will simply show How to Get the full SQL Server Instance Name using "SERVERPTOPERTY".

Difference between GROUP BY clause and DISTINCT in sql server. When and where to use GROUP BY and DISTINCT.

A Transact-SQL code snippet is a template containing the basic structure of a Transact-SQL statement or block. You can use snippets as a starting point when adding statements in the Database Engine...

This article will help the user to write a complex calculation in the backend (SQL SERVER). A computed column is computed from an expression that can use other columns in the same table.