CREATE TABLE YOUTABLE_B(ID BIGINT,NAME VARCHAR(200),ADDRESS VARCHAR(500))
CREATE TABLE YOUTABLE_A(ID BIGINT,NAME VARCHAR(200),ADDRESS VARCHAR(500),
DELETED_TIME SMALLDATETIME NOT NULL DEFAULT GETDATE())
INSERT INTO YOUTABLE_B VALUES(1,'YOUR_NAME','YOUR_ADDRESS')
INSERT INTO YOUTABLE_B VALUES(2,'YOUR_NAME','YOUR_ADDRESS')
Create TRIGGER dbo.TRG_YOU_TRG_NAME
ON dbo.YOUTABLE_B
FOR DELETE
AS
BEGIN
INSERT INTO dbo.YOUTABLE_A
(ID,NAME,ADDRESS,DELETED_TIME)
SELECT ID,NAME,ADDRESS,getdate()
FROM deleted;
END;
GO
DELETE FROM YOUTABLE_B WHERE ID = '1'
select * from YOUTABLE_B
select * from YOUTABLE_A
Hope so it will be usefull for you