what is magic table in sql?
what is a magic table in sqlserver?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Jan 7, 2013, 10:38 PM
Magic tables are nothing but "INSERTED" and "DELETED" table scope level (which are used in trigger), They are not physical tables, only Internal tables.
Magic Tables does not contain the information about the Columns of the DataType text,ntext or image.These are maintained by SQL Server for internal processing whenver an update,insert,Delete occur on table.
You can also use the Magic tables with Non-Trigger activities using OUTPUT Clause in SQL Server 2005, 2008 & 2008 R2 versions.
hope this will help you.
Satyapriya NayakPosted Jan 7, 2013, 9:35 AM
http://www.c-sharpcorner.com/UploadFile/rohatash/magic-tables-in-sql-server-2012/
http://www.c-sharpcorner.com/UploadFile/63f5c2/magic-table-in-sql-server/
http://vishalnayan.wordpress.com/2011/04/14/what-is-magic-table-in-sql-server/
http://www.dotnetspider.com/resources/29332-Magic-tables-SQL-Server.aspx