BULK INSERT your_table
from 'absolute/path/to/your/file'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
Obviously, you could also use different terminators, but all you need to do is to alter the specified parameter.
...or how to be heavyweight and agile at the same time
BULK INSERT your_table
from 'absolute/path/to/your/file'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)


However, in the last six minutes as 13 successive scrums were set five metres from the All Blacks line, and Neemia Tialata, having changed to the loosehead prop was sin-binned for taking a scrum down, the Italians were not able to get past a determined All Blacks pack.


@Test(expected=IllegalArgumentException.class)
public void makeBaby() {
Family family = moz.getFamily();
assertNotNull(family);
assertEquals(2, family.getChildren().size());
BabyFactory factory = family.getWife();
assertNotNull(factory);
Baby babygirl = factory.makeBabyGirl("Mila");
assertNotNull(babygirl);
family.addChild(babygirl);
assertEquals(3, family.getChildren().size());
boss.askForRaise(moz);
}
...for tonight is the night that my beautiful creature is destined to be born!


select *
from table_one
where my_key not in
(
select my_key
from table_two
)
select *
from table_one
where my_key not in
(
select cast (my_key as ${type}) collate ${collation}
from table_two
)
exec sp_help table_one
Englishmen play rugby because they invented it. Welshmen, Irishmen and Scots play rugby because if they bashed Englishmen in any other way they'd end up in jail.

@RunWith(JMock.class)
private Mockery context = new JUnit4Mockery();
@Test
public void testGetTable() {
System.out.println("getTable");
context.setImposteriser(ClassImposteriser.INSTANCE);
final LookupTableRepository repository = context.mock(LookupTableRepository.class);
final LookupTable table = context.mock(LookupTable.class);
final LookupTableFacadeResultFactory factory = context.mock(LookupTableFacadeResultFactory.class);
final LookupTableFacadeResult expResult = context.mock(LookupTableFacadeResult.class);
context.checking(new Expectations() {{
oneOf(repository).getTable(with(equal(tableName)));
will(returnValue(table));
oneOf(factory).make(with(equal(table)));
will(returnValue(expResult));
}});
LookupTableFacade instance = new LookupTableFacadeImpl(repository, factory);
LookupTableFacadeResult result = instance.getTable(tableName);
assertSame(expResult, result);
}
context.checking(new Expectations() {{
Matcher<LookupTable> tableNameMatcher = Matchers.hasProperty("tableName", equal(tableName));
oneOf(repository).save(with(tableNameMatcher));
will(returnValue(table));
oneOf(factory).make(with(equal(table)));
will(returnValue(expResult));
}});
Matcher<LookupTableItem> codeMatcher = Matchers.hasProperty("code", equal(code));
Matcher<LookupTableItem> descriptionMatcher = Matchers.hasProperty("description", equal(description));
oneOf(repository).save(with(allOf(codeMatcher, descriptionMatcher)));
will(returnValue(table));

After winning four Italian titles, after playing with the Italian National Team, after many satisfactions Pierpaolo Pedroni has been - way too early - summoned to play in the selection of rugby legends in the most beautiful stadium over the rainbow.Don't comment bad code - rewrite it.
"Ooh, I'd better comment that!" No! You'd better clean it!
Fear is the path to the Dark Side.
result = Normalizer.normalize(myString, Normalizer.Form.NFD);
return result.replaceAll("\\W", "").toUpperCase();
Our mentors have a way of seeing more of our faults than we would like... it is the only way we can grow.
The waterfall model is wrong!

right or wrong, I'm still the captain
OrderBuilder.createOrder()The builder actual code might look something like this:
.forCustomer(customer)
.with(STEAK, 1)
.with(FRIES, 1)
.with(BEER, 3)
.build();
public class OrderBuilder {
private final Order order;
private OrderBuilder() {
this.order = new Order();
}
public static OrderBuilder createOrder() {
return new OrderBuilder();
}
public OrderBuilder forCustomer(Customer customer) {
order.setCustomer(customer);
return this;
}
// ...similar setters ...
public Order build() {
// ...maybe perform some validation
return order;
}
}After playing with my code for a while I discovered that implementing a good fluent interface is not as easy as it might seem at first: you have to carefully think about what you really want to do (program by intention), how to clearly express it, and have your APIs reflect it. Nevertheless I think I'll experiment with them a little, they could be another nice trick in my toolbox.
It's not enough what I did in the past - there is also the future.
Ho perso un po' la vista, molto l'udito. Alle conferenze non vedo le proiezioni e non sento bene. Ma penso più adesso di quando avevo vent'anni. Il corpo faccia quello che vuole. Io non sono il corpo: io sono la mente.
Since MS Access is THE best application on the planet, you can right-click your way to happines...





Back in Dublin, where a huge crowd welcomed the whole team, captain Brian O'Driscoll said about the victory "it's been fantastic". When asked how he felt the day after he said "you're not as sore as you would be if you'd lost"... that made me smile, as it reminded me of good old times when rugby was not only something I could write about.
France seemed aghast last week, but they recovered pretty soon crushing and crunching Italy 8-50. The first of the seven tries holds Sebastien Chabal's signature: he broke not the first nor the last tackles in the day and scored calmly holding the ball with just one hand (yes, not one arm, one hand).






The defeat against France seems to have hit the Welsh more than it seemed ad first, up to the point that they were very close to losing the match to the best Italy seen so far. Shane Williams continued his scoring stripe, also keeping his average of one try per match against Italy; Shanklin's try finally gave Wales some of the breath they needed. Nevertheless, scoring two tries against zero wasn't enough to say that Wales really deserved to win, as what really costed Italy the match were their errors....now listen to my lay. For I will sing to you of Frodo of the Nine Fingers and the Ring of Doom.
And when Sam heard that he laughed aloud for sheer delight, and he stood up and cried: 'O great glory and splendour! All my wishes have come true!' And then he wept.
But Merry stood at the foot of the green mound, and he wept, and when the song was ended he arose and cried: 'Théoden King, Théoden king! Farewell! As a father you were to me, for a little while. Farewell!'
He drew a deep breath. 'Well, I'm back', he said.

Get this one. The same holds true for software systems. So you'd better consider it before you embark on the quest.
The only try scored by Ireland has O'Driscoll name, once and again named man of the match.
The strangest of things, this time I did not see Stringer play so close to the edge of the rules, in that unnerving manner I so often spot when I see him play. Again, just an impression of mine, but luckily impressions come for free and everyone can have their own.
Well at least there was a very good reason to be there: all the stadium sang the anthem without any instrument supporting voices, and it was really thrilling.
As predictable, Ireland showed no mercy for Italy, punishing them whenever they gave them an occasion - and Italy gave more than one. Maybe the final 9-38 is a bit too heavy, but Ireland was way better than Italy, except for the first 30 minutes in which the Azzurri managed to hold the field, thanks to a better organized scrum (this time they had a proper scrum half). In the remaining time Italy showed the will to produce good rugby, but, alas, they did not produce good rugby, never really worrying the Irish team which in turn scored five tries, two of them in the very last minutes, increasing their already remarkable advantage.
Unluckily for England this time Stephen Jones wore his right shoe on his right foot (and the left shoe on the left foot) and he booted 18 points for Wales, leading them to victory even if England scored two tries against the single one realized by young Halfpenny - who also booted a penaty.
Francesco Cirillo finally published the English version of his famous paper; you can find it here.