Post reply

Magic Table

  • September 14, 2005 at 3:22 am

    #89036

    Does anyone know what 'Magic Table' means, I was asked this recently in an interview......

  • September 14, 2005 at 5:20 am

    #589642

    Not in SQL Server - but perhaps it's something to do with Magic Software ???, check out:

    http://www.magicsoftware.com

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • September 14, 2005 at 8:06 am

    #589720

    The magic tables are the virtual tables available in a trigger:

    ie the [INSERTED] and [DELETED] tables, which can be referenced within a trigger so that you can add additional logic based on the values of the rows being inserted or deleted.

     

    Microsoft does not call them magic tables, by the way. dunno where the name started from. pretty crappy question to ask a candidate, if you ask me.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • September 14, 2005 at 12:34 pm

    #589859

    CM - I'm curious - are you by any chance from India ?! For some weird reason (unless it's coincidence) I've come across 2 posts referring to these "magic tables" and both post(ers) are from India...

    magic 1

    magic 2







    **ASCII stupid question, get a stupid ANSI !!!**

  • September 14, 2005 at 9:44 pm

    #589997

    Thanks a lot guys !!!!!

    Well, I too thought it was such a wierd thing to ask......... when in fact there are a lot of mind cracking questions to be asked in SQL Server....

     

     

     

     

  • September 15, 2005 at 9:38 am

    #590197

    I could use a dose of magic from time to time !

  • September 15, 2005 at 11:40 am

    #590273

    I only use the 'magic tables' in my 'PFM' database ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • September 15, 2005 at 12:52 pm

    #590303

    OK, I'll bite... PFM???

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • September 15, 2005 at 1:17 pm

    #590316

    PFM = 'pure f**king magic'

    analogous to the FM box

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply