Bookkeeping code or: how I learned to stop worrying and love data duplication
-
I feel like I'm walking into an ambush here but wouldn't you use ...
TRUNCATE [TABLE]
Lack of nested quoting support strikes again?
I am also finding absence of TRUNCATE TABLE a serious problem.
-
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.
-
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;
-
You may want to wrap that in
```
so it doesn't explode.
-
Looks stable enough to me.
-
Part of it got markdown link'd
-
I'm ok with this. Nagesh is a smart boy.
Well, ok, maybe not smart, but he is a boy.
I think.
-
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.
-
There's a fourth option, that @Nagesh is simply a very good troll.
-
For some reason, @Nagesh being a smart Indian playing a dumb Indian appeals to me more than @Nagesh just being some random troll.
-
I love the way your foul little mind works.
-
FWIW, morbs was convinced (99% IIRC) that @Nagesh is a non-Indian troll. He never explained to me his reasons for believing this.
-
Well he was a mod, so he probably saw an IP address.
-
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.
-
Or truthfulness.
-
Of course. I'm just saying that having an non-Indian IP address would not rule out having Indian ethnicity.
-
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.
-
He's actually French Canadian
-
He's actually French Canadian
Dubious. Those francophones would rather be thrown naked into the
St. LaurenceFleuve Saint-Laurent inJanuaryjanvier than useEnglishce maudit Anglais.
-
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.
-
My guess was that Nagesh is either a non-Indian living in India currently, or an Indian that now lives outside of India.
We could find out part of that by getting a moderator to check his IP (at least on CS), but I kind of like the mystery.
-
We could find out part of that by getting a moderator to check his IP (at least on CS), but I kind of like the mystery.
Could've tried to XSS him, but it all got fixed before anyone thought of it...
-
You're presuming there aren't still opportunities for that sort of behaviour.
-
You're presuming there aren't still opportunities for that sort of behaviour.
Shhh! Don't let @sam hear you.