Last post Apr 23, 2015 07:56 AM by PatriceSc
Apr 23, 2015 07:23 AM|sudip_inn|LINK
before we can access Deleted and Inserted magic table from Trigger only but i was reading a article on
output clause and there i was they are accessing those magic table from any store proc like this way
INSERT INTO dbo.Songs ( Id, Name, Singer)
OUTPUT Inserted.* INTO dbo.Songs_Inserted
VALUES (5, 'Duniya', 'Piyush Mishra');
so i like to know can we access magic table now from any where?
is it introduced from sql server 2008 ?
Apr 23, 2015 07:56 AM|PatriceSc|LINK
Even SQL Server 2005 according to https://msdn.microsoft.com/en-us/library/ms177564(v=sql.120).aspx
For these kind of questions your best bet is just to check the product documentation...