how to create magic table name
-
Hi all
how to create magic table name?
magic tables will created automatically when trigger fires, i want
to know that naming convention means tablename_insert like that, i want
correct formation
-
Do you mean the virtual tables that you can access to get the rows that where modified by the statement that triggered the trigger? If so, then they are called INSERTED and DELETED respectively.
-
Chris - hats off to your mastery in translation and interpretation - I would never have guessed this in a million years....
**ASCII stupid question, get a stupid ANSI !!!** -
Must be that I am not a native English speaker.
And we're not yet sure I made a correct interpretation anyway.
-
I think you did...make the right interpretation ie..
when I read the post I thought - "of the zillions of things I don't know here's one I haven't even heard of..." - then I read your response and immediately all bulbs came on at the same time!
**ASCII stupid question, get a stupid ANSI !!!** -
The whole question is here "when trigger fires". Not a bad guess at all
. -
"We do not work and live in FairyLand where elephants drop out of the sky by magic."
I live in South Florida so I'm used to big umbrellas. But I can't even imagine the size of one you'd need for this situation.
I don't need magic tables, thank you. But if anyone's got a magic wallet that they can spare...
My hovercraft is full of eels.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply