This article is to let you know how to import Excel data into SQL Server. First of all download a set of components i.e OLE
Category: SQL Server Functions
Generate multiple CSV data files from SQL
Assume that there are thousands of rows in a table and the rows need to be split and saved in different CSV files based on
SQL Server – Parsing, Casting and Conversion
Sometimes the data stores in the table in a different format in comparison to the real data type it belongs to. The date might be
Hijri Date in SQL Server – with Islamic Month Name
This article focuses on converting the Gregorian date into an Islamic date along with Islamic month name in textual format. In SQL Server there are
Json in SQL Server – Load and convert Json data
Data is the backbone of the business, and it can be in any sort of format. It can be lying in your relational databases or
Aggregate Functions in Analytic Context
The functions SUM, AVG, COUNT, MIN, and MAX are well-known aggregate functions that we use every day. They are to compute/summarize the multiple rows by
Big Data & SQL 