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
alter trigger TrigInsert on IMS.dbo.Status
উত্তরমুছুনfor insert
as
begin
delete from Tst.dbo.Status where empcode in(select * from inserted)
insert into Tst.dbo.Status
select * from inserted
end
alter trigger TrigInsert on IMS.dbo.Status
উত্তরমুছুনfor update
as
begin
delete from Tst.dbo.Status where empcode in(select empcode from inserted)
insert into Tst.dbo.Status
select * from inserted
end