SQL Server Performance

Magic table

Discussion in 'General DBA Questions' started by ardentphil69, Jan 15, 2006.

  1. ardentphil69 New Member

    hi every body<br /> Hey watz Magic table<br /> can anybody<br /> Plz hlp<br />[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />phil<br />
  2. Luis Martin Moderator

    I can't follow you.
    Can you give us a little more information?


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



  3. derrickleggett New Member

    It's a table that magically disappears, causing wide-spread panic among the general populace. Luckily, we have dragons to chase them down.

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  4. Luis Martin Moderator

    Also those matrix with the same sum in any direction[<img src='/community/emoticons/emotion-2.gif' alt=':D' />].<br /><br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.<br />Leonardo Da Vinci<br /></font id="size1"><br /><font size="1"> Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte<br /></font id="size1"><br /><br /><font size="1">All postings are provided “AS IS” with no warranties for accuracy.</font id="size1"><br /><br /><br /><br />
  5. Madhivanan Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by ardentphil69</i><br /><br />hi every body<br /> Hey watz Magic table<br /> can anybody<br /> Plz hlp<br />[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />phil<br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Well. You are referring the tables inserted and deleted that you can access from Triggers. As a beginner you are referring them as Magic Tables. But they are actually not called as such. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  6. FrankKalis Moderator

    42 [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  7. benwilson New Member

    You guys are great...to give a helpful answer, i think more information would be required...in the meantime, i think it has to be the table used by a magician to put his top hat on when removing the rabbit from it.



    'I reject your reality and substitute my own' - Adam Savage
  8. FrankKalis Moderator

  9. Madhivanan Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by FrankKalis</i><br /><br />Okay, getting serious again. <br /><br />Phil, please be more specific if your question was serious and if you expect a serious answer.<br /><br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />I have seen many Newbies thinking inserted and deleted tables as Magic Tables [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  10. FrankKalis Moderator

    In PHP you have something called "Magic Quotes". It is described as follows<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><br />Magic Quotes is a process that automagically escapes incoming data to the PHP script. It's preferred to code with magic quotes off and to instead escape the data at runtime, as needed. <br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  11. satya Moderator

  12. FrankKalis Moderator

    To quote the article<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><br />Magic tables<br /><br />The INSERTED and DELETED tables, popularly known as MAGIC TABLES, and update () and columns_updated() functions can be used to determine the changes being caused by the DML statements.<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />I must confess, I've never heard this term before. Nor wasn't I aware that the INSERTED and DELETED tables are meant. <br />Do I think, this term is useful? No, definitely not! [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  13. satya Moderator

    In this open source world, sometimes it takes you to a software tool called Magic. As it uses SQL server too for data storage. I would wait until Phil comes back with what is in his mind about this concept [<img src='/community/emoticons/emotion-5.gif' alt=';)' />].<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
  14. Madhivanan Moderator

    >>I've never heard this term before

    Well. When I was a newbie, I was told that Inserted and Deleted tables are Magic tables
    But there is no such information in BOL or MSSQL site.

    Madhivanan

    Failing to plan is Planning to fail
  15. Luis Martin Moderator

    In my first post I was searching in BOL, MS and google and find nothing.
    Obviusly I search wrong.

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



  16. Kiruba Jeyaseelan New Member

    The INSERTED and DELETED tables, popularly known as MAGIC TABLES, and update () and columns_updated() functions can be used to determine the changes being caused by the DML statements. Note that the Magic Table does not contain the information about the columns of the data-type text, ntext, or image. Attempting to access these columns will cause an error. This answer was posted at dotnetspider Reference URL: http://www.dotnetspider.com/kb/Article1733.aspx
  17. Madhivanan Moderator

    I think this is the link given by satya in his first reply
  18. satya Moderator

    [:)] I was wondering whats the hub-hub with this old thread, great catch.

Share This Page