SQL Server 2012

Get SQL Server Info Using SERVERPROPERTY

How to Get SQL Server Info Using SERVERPROPERTY?

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. Download the full SQL Query from GitHub at Get The Detailed SQL Server Information. What’s …

How to Get SQL Server Info Using SERVERPROPERTY? Read More »

How to get the update level in SQL Server 2016

Consider you need to install a new Cumulative Update or Service Pack on your current SQL Server, but you don’t know what’s the current update level that already installed in your environment!! In this article, we will explain How to get the update level in SQL Server 2016 and detect the current installed Cumulative Update / …

How to get the update level in SQL Server 2016 Read More »

convert rows to columns in sql server

Convert Rows To Columns In SQL Server Using Dynamic Pivot

In this article, we will explain how to Convert Rows To Columns In SQL Server Using Dynamic Pivot step by step. Applies To SQL Server 2017. SQL Server 2016. SQL Server 2012. SQL Server 2008. You might also like to read Dynamic pivot without aggregate function in SQL Server Using Dynamic Pivot to Convert Rows …

Convert Rows To Columns In SQL Server Using Dynamic Pivot Read More »