Data Integrity In SQL Server
Deepak Tewatia
In this blog, we will look into steps to be followed for fixing invalid column name ‘ABC’ Error while accessing a newly-added column.
Sateesh Arveti
The word “Manipulation” means to play with the data, not only retrieve or fetch the data. We can include retrieve, store, modify, delete, insert, update and copy operations in DML.
Dharmraj Thakur
When we have more databases on a Server to backup, it is very time-consuming to backup all databases manually. In such cases, we can use T-SQL to automate these tasks. We can use SQL Server Managem...
Nishan Aryal
In this blog i am going to explain how to remove duplicate records from a table in SQL Server.
Nikunj Satasiya
I have SQL server Table in which there is column that I wanted to update according to a 2 columns value that are present in current row. In this scenario, we can use CASE expression. CASE expressio...
Sagar Shinde
Email Address is truncated with the use Convert and Varchar.
Manish Pandey
Transfer database from SQL Server 2008 to 2014 using different migration techniques with the help of this article.
Andrew Jackson
In this blog, we are trying to find in how many ways, we can find foreign key in SQL Server.
Pramod Thakur
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
Mohamed Elqassas Mvp
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