+purpose: sql server bcp examples
+/* create a table to play with */
+truncate table [dbo].[tempchu];
+/* Generate non-xml and xml format files from the tempchu table */
+bcp "[AdventureWorks2012].dbo.[tempchu]" format nul -f "C:\myscratch\tempchu.fmt" -T -c -t,
+--create format xml file
+bcp "[AdventureWorks2012].dbo.[tempchu]" format nul -c -x -f "C:\myscratch\tempchu.xml" –t, -T
+/* use the non-xml format file to load data into the table */
+bcp "[AdventureWorks2012].dbo.[tempchu]" IN "C:\myscratch\tempchu.csv" -c -f "C:\myscratch\tempchu.fmt" -T -S localhost
+/* Query the table. Verify that new data was loaded correctly */
+select * from [dbo].[tempchu];
+/* Sample load and unload using bcp */
+bcp.exe "[AdventureWorks2012].dbo.[tempchu]" out "C:\myscratch\tempchu.dat" -x -n "C:\myscratch\tempchu.xml" -T -S localhost
+bcp.exe "[AdventureWorks2012].dbo.[tempchu]" in "C:\myscratch\tempchu.dat" -n -T -S localhost
