In this article, we will explain how to Get SQL Server info using SERVERPROPERTY, we will also provide a complete SQL Query to get all detailed information of the current installed SQL Server, like version, instance name, build number …etc. You might also like to read SQL Server Best Practices for SharePoint 2019 What’s the SERVERPROPERTY […]
Get SQL Server Info Using SERVERPROPERTY() Read More »
In this article, we will explain how to create Transaction LOG BACKUP Maintenance Plan as well as we will learn how to restore transaction Log Backup in SQL Server? Applied To SQL Server 2017. SQL Server 2016. SQL Server 2012. What’s Transaction LOG BACKUP? Each database has two main types of files, Data file, and
Create Transaction LOG BACKUP Maintenance Plan in SQL Server Read More »
In this article, I will explain how to Convert Decimal Numbers to Money with cents / without cents in SQL. You might also like to read How to convert Gregorian date to Hijri date SQL Server 2012 Convert Decimal to Money SQL I have a decimal number like 71567536.100000, I need to convert it to money format with
Convert Decimal to Money SQL Read More »
