需要在SQL表上触发，在表中插入时触发PHP脚本

Question

I want to know if we can create a trigger in MS SQL server which triggers a php script on each insertion of record

Answer 1

Not sure why you want it, but try something in the line of:

DELIMITER @@

CREATE TRIGGER SomeTrigger 
AFTER INSERT ON SomeTable 
FOR EACH ROW 
BEGIN
   DECLARE cmd CHAR(255);
   DECLARE result int(10);
   SET cmd=CONCAT('sudo /path/to/php -f file.php');
   SET result = sys_exec(cmd);
END;
@@
DELIMITER ;