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 />
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.
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.
Also those matrix with the same sum in any direction[<img src='/community/emoticons/emotion-2.gif' alt='' />].<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 />
<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
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 />
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
Okay, getting serious again. Phil, please be more specific if your question was serious and if you expect a serious answer. -- Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de Heute schon gebloggt?http://www.insidesql.de/blogs
<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
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 />
Having said most out it on lighter side and serious side, referhttp://www.dotnetspider.com/kb/Article1733.aspx for your information. Satya SKJ Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
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 />
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>
>>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
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.
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
