Trigger for insert or delete record.

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

change mysql file size limit, Execution time limit....

or

Try these different settings in C:\wamp\bin\apache\apache2.2.8\bin\php.ini



Find:
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

Change to:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M

Then restart wamp to take effect



Thanks.





Contact Us
Email: ritbd.com@gmail.com
Cell: +88 019 12345 565