Academic Paper
This is the academic paper
for the library sqlserver
. There is new features and stuff that is not mentioned in this paper but it is a good start to understand the library and also the algorithms used.
It explains the core principles of batch insertion, Getting of dictionaries
using SELECT
queries and returning columns as lists
.
You may look click the link below to view the paper. All the additional features and stuff will be on this website for the future reference.
The Mass Insertion of SQL Server Records Algorithm (opens in a new tab)
Publication date:
November 9, 2022
Keyword(s):
sqlserver python pandas insert
License:
Creative Commons Attribution 4.0 International
Cite as
Ashlin Darius Govindasamy. (2022). The Mass Insertion of SQL Server Records Algorithm. https://doi.org/10.5281/zenodo.7306173 (opens in a new tab)