Viewing 15 posts - 1 through 15 (of 20 total)
To use a pipe delimiter between each field, use the -t "|" option. -r is the row delimiter
December 3, 2013 at 12:08 am
Toby Harman (7/5/2011)
July 5, 2011 at 7:30 pm
great question. I never realised Go accepted an option... now I just need to find a use for it 😉
June 23, 2011 at 9:08 pm
Nice question. I got so caught up wondering why you chose union instead of union all that I missed the smalldatetime. doh!
June 23, 2011 at 8:46 pm
Good question Steve! 4 seemed too obvious to me as well.
May 4, 2011 at 12:38 am
I think the reason this works is that the NULL in the CREATE TABLE is an attribute of the column (since NULL is actually just a...
April 26, 2011 at 9:17 pm
Being an Aussie, I found this US based question harder than most of the others! Nailed it 🙂
April 14, 2011 at 9:18 pm
I'd like to add one point to your great article. DW ROI is not proportionate to the development time invested.
Some business areas can provide high ROI, with...
April 10, 2011 at 7:50 pm
I thought I'd nailed this one, but sadly was wrong. Nice to know, thanks for the great question.
April 6, 2011 at 7:43 pm
Great question, thanks! I went for tinyint on the assumption it was 1 byte of storage and compression overhead - got it wrong, but learned something new 🙂
April 4, 2011 at 9:48 pm
Nice question, thanks.
March 31, 2011 at 6:36 pm
Great question, thanks!
I lost a point here, but it was well worth it as I hadn't even considered collation when I answered.
March 30, 2011 at 9:42 pm
Great question considering 64% of the answers were incorrect! I came across this issue a short while ago which jogged my memory for this question, but nice to know. Thanks
March 30, 2011 at 6:39 pm
Good question for general knowledge, thanks.
March 30, 2011 at 12:53 am
I thought I'd sneak in a quick question or 2 while I was at work...then all that date math took 10 minutes to work out, and now its home time!...
March 30, 2011 at 12:38 am