SQL Server, like all other major RDBMS, supports ANSI SQL, the standard SQL language. SQL Server also contains T-SQL and its implementation. SSMS- the SQL Server Management Studio known as Enterprise Manager earlier is SQL Server’s main interface to…
Data can be kept in different media, Sometimes, the data need to be extracted, transformed or loaded in different ways.
For this article, I'm going to demonstrate some of the popular ways of importing Excel data into MS SQL Server.