Re: Table Value Parameter for SQL server

2022-11-11 Thread Keith Carangelo
Hi Rich. I had a similar task and for me the best way to bulk import a large number of rows into SQL Server was to use the bcp utility. Here's a great resource for it: https://www.red-gate.com/simple-talk/sql/database-administration/working-with-the-bcp-command-line-utility/ I create a tab-delim

Table Value Parameter for SQL server

2022-11-05 Thread Rich Duzenbury
Hi All, I am attempting to bulk merge a lot of rows quickly to an mssql server and I understand that table value parameters are a possible option for doing so. I set up the following test objects on the sql server (modeled after a python example of sorts from https://github.com/mkleehammer/pyodbc