Bookkeeping code or: how I learned to stop worrying and love data duplication

boomzilla

@RTapeLoadingError said:

I feel like I'm walking into an ambush here but wouldn't you use ...

TRUNCATE [TABLE]

Lack of nested quoting support strikes again?

@Nagesh said:

I am also finding absence of TRUNCATE TABLE a serious problem.

Nagesh

@RTapeLoadingError said:

I feel like I'm walking into an ambush here but wouldn't you use ...

<code> TRUNCATE [TABLE] </code>

There are instances where TRUNCATE simply doesn't work. One is FKEY reference. If the table you're referencing is having a foreign key referencing it, database will not allow TRUNCATE.

Here is sql server fiddle for that.

SQL Fiddle - Online SQL Compiler for learning & practice

Matches

ALTER TABLE [dbo].[child]
drop CONSTRAINT FK_child_parent1;

TRUNCATE TABLE parent1;

ALTER TABLE [dbo].[child] WITH CHECK ADD CONSTRAINT [FK_child_parent1] FOREIGN KEY([parent_id])
REFERENCES [dbo].[parent1] ([parent_id])

select * from parent1;

ben_lubar

You may want to wrap that in ``` so it doesn't explode.

Matches

Looks stable enough to me.

ben_lubar

Part of it got markdown link'd

Matches

I'm ok with this. Nagesh is a smart boy.

Well, ok, maybe not smart, but he is a boy.

I think.

ben_lubar

I have three competing hypotheses in my head about @Nagesh:

@Nagesh is an illiterate Indian person who happened to find this forum and stayed for the same reasons as @SpectateSwamp.
@Nagesh is a literate Indian person who has managed to stay in character for ages now.
@Nagesh is the ghost of a comedian who died in 2009 haunting this forum.

Arantor

There's a fourth option, that @Nagesh is simply a very good troll.

ben_lubar

For some reason, @Nagesh being a smart Indian playing a dumb Indian appeals to me more than @Nagesh just being some random troll.

Arantor

I love the way your foul little mind works.

HardwareGeek

FWIW, morbs was convinced (99% IIRC) that @Nagesh is a non-Indian troll. He never explained to me his reasons for believing this.

ben_lubar

Well he was a mod, so he probably saw an IP address.

HardwareGeek

I seem to recall @Nagesh having claimed at one point to live in London, so an IP address wouldn't necessarily say anything about his ethnicity.

Arantor

Or truthfulness.

HardwareGeek

Of course. I'm just saying that having an non-Indian IP address would not rule out having Indian ethnicity.

Arantor

Indeed. But I wouldn't assume that just because Nagesh says he's from Hyderabad, India that he would be Indian by ethnicity, or indeed that he actually is Indian at all in any respect (ethnicity or otherwise)

This is the internet. The men are men, the women are men, and the children are the FBI, except for the ones that aren't.

Matches

He's actually French Canadian

HardwareGeek

@Matches said:

He's actually French Canadian

Dubious. Those francophones would rather be thrown naked into the ~~St. Laurence~~Fleuve Saint-Laurent in ~~January~~janvier than use ~~English~~ce maudit Anglais.

darkmatter

My guess was that Nagesh is either a non-Indian living in India currently, or an Indian that now lives outside of India. They clearly have a decent grasp on Indian culture - better than I'd think would be reasonably worthwhile to research just for trolling a small forum like this one.