觸發器： ALTER PROCEDURE ControllerTooEnterprise???? --插入實際控制人的同時更新企業從業人員總數和企業規模@EnterpriseID INT,@Enterprise_People INT,@TrainAll INT,@Enterprise_Scale DECIMAL(9),@ControllerName VARCHAR(50),@ControllerTel VARCHAR(50) ASBEGINDECLARE @SQL1 VARCHAR(100);DECLARE @SQL2 VARCHAR(100);SET @SQL1='INSERT INTO Controller (ControllerName,ControllerTel,TrainAll,EnterpriseID) VALUES ('''+@ControllerName+''','''+@ControllerTel+''','''+@TrainAll+''','''+@EnterpriseID+''')'SET @SQL2='UPDATE Controller SET (Enterprise_People='+@Enterprise_People+',Enterprise_Scale='+@Enterprise_Scale+') WHERE EnterpriseID='+@EnterpriseIDEXECUTE(@SQL1);EXECUTE(@SQL2);END 執行： EXECUTE ControllerTooEnterprise 1503,888,888.88,0,'LEE JUN','13998989966' 消息： 將 varchar 值 'INSERT INTO Controller (ControllerName,ControllerTel,TrainAll,EnterpriseID) VALUES ('LEE JUN','15398959966','' 轉換為數據類型為 int 的列時發生語法錯誤。 ? ? 這到底是個什么情況呢？ 頭疼