The below is a list of all of the articles that have been written on this blog.
Category: RDBMS
Apache Hive Aggregate Functions – Part-2
This is continuation part of “Apache Hive Aggregate Functions” Function: VARIANCE & VAR_POP Returns the population variance of the total number of records present in
Convert Delimited Data Into Columns In MySQL
This article addresses the conversion of the delimited data into columns in MySQL. There are is a function called “SUBSTRING_INDEX” that helps us convert the
Convert Delimited Data Into Columns In SQL Server
This article addresses the conversion of the delimited data into columns in SQL Server. There are two functions called “STRING_SPLIT” and “PARSENAME” that helps us
Reserved Keywords As Columns In SQL Server
In this post, we’re going to talk about using reserved keywords as column names. This is very similar to the previous “IMPALA – Reserved Keywords
Failed to initialize sqlcmd library with error number -2147467259.
While sending the mail through SQL Server using DBMail, sometimes we get the error message “Failed to initialize sqlcmd library with error number -2147467259”. This
Big Data & SQL 