Question : I have a lot of large tables (around 10 million wide rows) which need to be regularly loaded […]
Tag: bcp
BCP Insert through View vs Manual insert
Question : Consider the following code use tempdb go drop table if exists ImportTest1; create table ImportTest1 ( Column1 int […]
Can Unicode columns include non-Unicode values in SQL Server?
Question : I need to convert Unicode column values from UTF16-LE to UTF-8 to then import into MySQL. Is it […]
after insert trigger not firing after inserting with bcp
Question : content of csv file TEST_1|sl2sysxbar301.dv.local|{‘message_type’: 2, ‘super_evt_non_error’: {‘a0’: 0, ‘a1’: 0, ‘a2’: 0, ‘a3’: 0, ‘event’: 5528, ‘event_string’: […]
How to troubleshoot “BCP copy in failed”
Question : I have a table that looks something like this in a SQL server database in Azure: CREATE TABLE […]
BCP To Copy Headers
Question : I am using a stored procedure to populate a table with the data that I need. I am […]
How to load a table using BCP
Question : Context: I created a dump of a sql table in XML (Including data and schema) using this command […]
Optimising BCP performance for BLOB data
Question : I’m the process of planning the live migration of a 2TB database to partitioned tables. The system is […]
Minimum requirements to run Sql Server BCP.exe utility
Question : I am working with a client who needs to do a data import to a remote SQL Server […]
BCP error near the keyword ‘as’
Question : I am new to using BCP but I am trying to extract data generated via a stored proc. […]