Daily Digest for June 27th, 2009

Will Dearman's Lifestream Daily Digest for June 27th, 2009 includes 3 items:
Defeated by SQL server today! I'm having issues getting large amounts of text (XML) into an nText field. It is totally beyond me right now [#]
7:03pm via Twitter
Figured it out... needed single quotes and no apostrophes or line breaks. Success FTW! We are almost there. Will totally "CRUSH IT!" next wk [#]
8:04pm via Twitter
Interesting post by @thinkc about health insurance and its affect on entrepreneurship http://bit.ly/1bxeu [#]
8:05am via Twitter

Daily Digest for May 13th, 2009

Will Dearman's Lifestream Daily Digest for May 13th, 2009 includes 3 items:
Shared 8 links.
5:41pm via Google Reader
6:05pm via Google Reader
<tech speak> Rejoycing that I finally got DTS to work on our SQL 2008 Express install. No more BCP XML export garbage </tech speak> [#]
6:17pm via Twitter

Extracting Table Data from SQL Express 2005 using BCP [SOLVED]

This took an unfortunate amount of time to figure out, so here goes: 1) Using the command prompt (NOT THE QUERY WINDOW), type: bcp DatabaseName.TableName out nul -c -fTemplate.dat -Slocalhost\SQLEXPRESS -T 2) The result should be a file named Template.dat that will contain your column headers from that table. 3) Now using the command prompt type: bcp DatabaseName.TableName out D:\TableData.dat -c -fTemplate.dat -Slocalhost\SQLEXPRESS -T 4) The result should be a file named D:\TableData.dat that contains all of that table's data. Additional Notes: It turns out I was running an old version of BCP, which is why I could only use tab-delimited file formats and not XML (the -x parameter). More info here. To use XML, which is preferable, simply add the -x parameter to step 1. Currently upgrading to SQL 2008 Express to resolve the issue.