Insert local .csv data in remote SQL Server via already working connection string

by

At this point in your code you have only connected to your database. Please look at an example here in stackoverflow that may help you to see what your next steps could be (it refers to MySQL but it is still instructive):

Perl inserting into MySQL DB

Also, I would recommend what user Matt Jacob mentions in his comments and also the book “Programming the Perl DBI: Database programming with Perl” by Tim Bunce and Alligator Descartes.

HTH

More Related Contents:

  1. T-SQL split string
  2. Conditional WHERE clause in SQL Server
  3. Multi-statement Table Valued Function vs Inline Table Valued Function
  4. SQL Server Insert if not exists
  5. Remove trailing zeros from decimal in SQL Server
  6. GROUP BY to combine/concat a column [duplicate]
  7. SQL Server – In clause with a declared variable [duplicate]
  8. How to set table name in dynamic SQL query?
  9. How to turn IDENTITY_INSERT on and off using SQL Server 2008?
  10. Copy data into another table
  11. EXISTS vs JOIN and use of EXISTS clause
  12. SQL Server 2008 – IF NOT EXISTS INSERT ELSE UPDATE
  13. Why is a UDF so much slower than a subquery?
  14. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  15. Query runs slow with date expression, but fast with string literal
  16. Alternate of lead lag function in SQL Server 2008
  17. UNIX_TIMESTAMP in SQL Server
  18. Generate all combinations in SQL
  19. The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range?
  20. Add emoji / emoticon to SQL Server table
  21. SQL Server SELECT INTO @variable?
  22. How to subtract 30 days from the current date using SQL Server
  23. Count records for every month in a year
  24. How to export data from Excel spreadsheet to Sql Server 2008 table
  25. SQL Server: +(unary) operator on non-numeric Strings
  26. Use one CTE many times
  27. Connect different Windows User in SQL Server Management Studio (2005 or later)
  28. How to Select Every Row Where Column Value is NOT Distinct
  29. How to do a case sensitive GROUP BY?
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment