tag:blogger.com,1999:blog-6357505892638015674.post2245076937262200613..comments2023-12-11T22:43:08.539-08:00Comments on Welcome to SQLServer MVP Blog: Magic Tables in SQL ServerUnknownnoreply@blogger.comBlogger6125tag:blogger.com,1999:blog-6357505892638015674.post-5395175619994661132011-02-17T03:04:36.825-08:002011-02-17T03:04:36.825-08:00hi Venkatesan prabu,
really this is very nice.bec...hi Venkatesan prabu,<br /><br />really this is very nice.because we have all information data which have been update or delete from table.Rahul Choudharyhttps://www.blogger.com/profile/13339949742392736466noreply@blogger.comtag:blogger.com,1999:blog-6357505892638015674.post-48024016381819716422010-09-20T22:59:17.790-07:002010-09-20T22:59:17.790-07:00Thanks Venkat,
God Bless U
Take Care n
Keep Smili...Thanks Venkat,<br />God Bless U <br />Take Care n<br />Keep Smiling<br /><br />Warm Regards<br />Sagar Vernekar<br /><br />Software Engineer<br /><br />Mob - +91-9881640866Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6357505892638015674.post-20659839370293363362009-06-24T04:32:41.541-07:002009-06-24T04:32:41.541-07:00Thanks Venkat
asking about to explain the query w...Thanks Venkat<br /><br />asking about to explain the query what you have written. Not, what is Magic table! <br /><br />what is that VENKAToutput and so many variables you used there.<br /><br />please explain in detail line by line<br /><br />Thanks<br />Kalyankalyanhttps://www.blogger.com/profile/01153620569816679859noreply@blogger.comtag:blogger.com,1999:blog-6357505892638015674.post-73730658991764311582008-07-19T23:22:00.000-07:002008-07-19T23:22:00.000-07:00Thanks for writing your feedback in my blog.Ok, Le...Thanks for writing your feedback in my blog.<BR/><BR/>Ok, Let me explain you about the article.<BR/><BR/>Magic tables are inherent property of a trigger.<BR/><BR/>Suppose considering am writing a trigger to update a row.<BR/>Suddenly, I thought like, I need my old value. Is it possible to retrieve it?<BR/><BR/>Yup, Its possible by using Magic tables. The old value get stored in the magic table.<BR/>If we run the second trigger the second trigger data will get stored into the magic table.<BR/><BR/>Any suggestions, feedback... or if you want more info.. please let me know.<BR/>Regards,<BR/>Venkatesan prabu .JVenkatesan Prabuhttps://www.blogger.com/profile/02685812384505488301noreply@blogger.comtag:blogger.com,1999:blog-6357505892638015674.post-36093317310005554342008-07-11T22:17:00.000-07:002008-07-11T22:17:00.000-07:00Hi Venkat, Im Sundar. First, I would like to say t...Hi Venkat,<BR/> Im Sundar. First, I would like to say thanks. Then im sorry, I cant understand ur code. Can u explain clear?<BR/>And one more thing is i have more than 150 tables in my office. I cant write this code for 150 tables. So i need one code it will affact all my 150 tables. Can u help me?Sundarhttps://www.blogger.com/profile/04925369799117392297noreply@blogger.comtag:blogger.com,1999:blog-6357505892638015674.post-15944999469441757722008-07-11T21:35:00.000-07:002008-07-11T21:35:00.000-07:00Hi Venkat, Im Sundar. First, I would lik...Hi Venkat,<BR/> Im Sundar. First, I would like to say thanks. Then sorry, i cant understand ur code. Can you explain clear?<BR/> And one more things is i have more than 150 tables in my office. so i cant write this for 150 tables. so I need one code for all my 150 tables.<BR/> Thanks a lot.Sundarhttps://www.blogger.com/profile/04925369799117392297noreply@blogger.com