Posts Tagged ‘Database’

SQL Server doesn’t need any introduction as it is a widely used product from a technology giant Microsoft.

But very few of them actually know the history of sql server and obviously I m one of them few days ago. This post is about the same……. (more…)

Advertisements

When you are dealing with bulk data then all you have is a CSV file. Comma Separated Value File or CSV file is a data file which contains large amount of data separated by comma.

The scenario is you have to insert the given data in SQL Server and the question is What will you do?

Option 1: Map fields one by one

Option 2: Use a small function called Sql Bulk Insert to insert data in the table. (more…)