Trigger for backup data from sales table of dbPicnPay to Sales table of dbBackUp database. After Delete record from sales table of dbPicnPay that record will insert into Sales table of dbBackUp database.
create trigger TrigSalesHistory on dbPicnPay.dbo.Sales
for delete
as
begin
insert into dbBackUp.dbo.Sales
select * from deleted
end
Trigger for backup data from sales table of dbPicnPay to SalesNew table of dbBackUp database. After Insert record to sales table of dbPicnPay that record will also insert into SalesNew table of dbBackUp database.
create trigger TrigSalesHistory on dbPicnPay.dbo.sales
for insert
as
begin
insert into dbBackUp.dbo.SalesNew
select * from inserted
end
After Insert/Delete record from Sales table of dbPicnPay that operation make failed:
create trigger SalesHistoryS on dbPicnPay.dbo.sales
for delete,insert
as
begin
rollback
end