trigger
how to create a trigger after insert data in 1 table,delete that data from another table.
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 Sep 11, 2012, 11:49 PM
First refer
http://stackoverflow.com/questions/1935691/how-to-use-text-ntext-or-image-columns-in-the-inserted-and-deleted-tables
Try..
CREATE TRIGGER SomeInsertTable
ON TableName AFTER INSERT AS
BEGIN
--Delete Action
END
In the delete action write your code.
for mare help please refer.
http://msdn.microsoft.com/en-us/library/ms189799.aspx
Sukesh MarlaPosted Sep 11, 2012, 2:25 PM
as per following link image datatype will be removed in future releases.
http://msdn.microsoft.com/en-us/library/ms189799.aspx
vikas kananiPosted Sep 11, 2012, 4:06 AM
Sukesh MarlaPosted Sep 10, 2012, 1:33 PM
Check this is correct answer if it helped.