Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
paritosh
Starting Member
42 Posts |
 Posted - 2011-09-09 : 03:34:00
|
| what is magic tables in sql server when its used and when triggers fire the data is goes where if any data store . |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-09 : 03:40:43
|
| magic tables used in sql server are inserted and deleted. when trigger fires, all old data (for deletes/updates) will be in deleted table and all the newdata(inserts/updates) will be in inserted table. also this table will dynamically assume structure of main table on which trigger is created. now you can use them outside of trigger also by using output clause (from sql 2005 onwards)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-09 : 11:22:03
|
| http://www.midnightdba.com/Jen/2011/03/maaaaaagic-tables/(by the way, pretty sure the term -- which bothers me too -- came from the open source world, specifically php and my favorite security hole ever built in to a programming language) |
|
|
|
|
|
|
magic table in sql server