Hello all, The below tutorial will help you in displaying SQL row data as a column wise with user specific column name. here, I've a table with #Temp1 name that contains the following columns Id, ...

With SQL Server 2016, it now makes sense to store JSON objects in your database (even though there’s no JSON datatype). Here’s how to query JSON properties to find the rows you want.

With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the database and down to the client. SQL Server ...

Impala/Hive SQL Pivot Example This example describes how Impala SQL can be used to pivot columns to rows and vice versa. Most relational databases such as Oracle and MS SQL provide some form of built ...

About the Author Eric Johnson, SQL Server MVP, is the owner of Consortio Services in Colorado Springs providing IT systems management and technology consulting.