In this post I would like to talk about how to import and export data using the bcp utility. I will also explain how the bcp utility works with tables that have constraints and triggers attached on them. No databases exist in isolation.
Bulk Insert Data into SQL Server
BCP Bulk Insert issue with double quotes - Microsoft Q&A
c# - Additional bytes being prepended to file when saved to SQL
An introduction to the bcp Utility (bulk copy program) in SQL Server
Using HierarchyID system data type in SQL Server 2008
How should I write an insert statement inside a stored procedure
Create a master-detail Windows Forms application with EF
An introduction to the bcp Utility (bulk copy program) in SQL Server
Techniques to bulk copy, import and export in SQL Server
Optimising SQL Server for ad hoc workloads