MS-SQL 触发器 “转换为数据类型为 int 的列时发生语法错误”

Question

触发器：

ALTER PROCEDURE ControllerTooEnterprise     --插入实际控制人的同时更新企业从业人员总数和企业规模
@EnterpriseID INT,
@Enterprise_People INT,
@TrainAll INT,
@Enterprise_Scale DECIMAL(9),
@ControllerName VARCHAR(50),
@ControllerTel VARCHAR(50)

AS
BEGIN
DECLARE @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='+@EnterpriseID
EXECUTE(@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 的列时发生语法错误。

 

 

这到底是个什么情况呢？ 头疼