trigger

Question

how to create a trigger after insert data in 1 tabledelete that data from another table.

Jignesh Trivedi · Answer

hi 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 Marla · Answer

use varchar(max) instead of image as per following link image datatype will be removed in future releases. http://msdn.microsoft.com/en-us/library/ms189799.aspx

vikas kanani · Answer

it correct.but in my table there is 1 colum is of imagedata.so trigger is not generated...do smthing.

Sukesh Marla · Answer

CREATE TRIGGER backupDatata ON MyOldTable AFTER Delete AS BEGIN SET NOCOUNT ON; Insert into MyBackupTable Select * from deleted END Check this is correct answer if it helped.