插入数据的存储过程错误！！！，高的莫名其妙

[qushui]

存储过程内容如下
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
/**
* Add send log to db
*/

CREATE PROCEDURE e_addnew_subscribe_send_log
@esl_id int,
@et_id int,
@es_id int,
@essl_code int,
@essl_desc nvarchar(2000)
AS
declare @str nvarchar(4000)
set @str=N'INSERT INTO e_subscribe_send_log_'+cast(@esl_id as Nvarchar(10))+N' (et_id, es_id, essl_code, essl_desc) VALUES ('+cast(@et_id as Nvarchar(10))+N','+cast(@es_id as Nvarchar(10))+N','+cast(@essl_code as Nvarchar(10))+N','+cast(@essl_desc as Nvarchar(1000))+N')'
exec(@str)

GO


=============================================
执行
dbo.e_addnew_subscribe_send_log 8,10,2,255,'ssaas'


=================================================
错误如下
服务器: 消息 128，级别 15，状态 1，行 1
在此上下文中不允许使用 'ssaas'。此处只允许使用常量、表达式或变量。不允许使用列名。

[pengdali]

CREATE PROCEDURE e_addnew_subscribe_send_log
@esl_id int,
@et_id int,
@es_id int,
@essl_code int,
@essl_desc nvarchar(2000)
AS
declare @str nvarchar(4000)
set @str=N'INSERT INTO e_subscribe_send_log_'+cast(@esl_id as Nvarchar(10))+N' (et_id, es_id, essl_code, essl_desc) VALUES ('+cast(@et_id as Nvarchar(10))+N','+cast(@es_id as Nvarchar(10))+N','+cast(@essl_code as Nvarchar(10))+N','''+cast(@essl_desc as Nvarchar(1000))+N''')'
exec(@str)

GO

[CrazyFor]

TRY:


CREATE PROCEDURE e_addnew_subscribe_send_log
@esl_id int,
@et_id int,
@es_id int,
@essl_code int,
@essl_desc nvarchar(2000)
AS
declare @str nvarchar(4000)
set @str=N'INSERT INTO e_subscribe_send_log_'+cast(@esl_id as Nvarchar(10))+N' (et_id, es_id, essl_code, essl_desc) VALUES ('+cast(@et_id as Nvarchar(10))+N','+cast(@es_id as Nvarchar(10))+N','+cast(@essl_code as Nvarchar(10))+N','''+cast(@essl_desc as Nvarchar(1000))+N''')'
exec(@str)

GO

[CrazyFor]

TRY:


CREATE PROCEDURE e_addnew_subscribe_send_log
@esl_id int,
@et_id int,
@es_id int,
@essl_code int,
@essl_desc nvarchar(2000)
AS
declare @str nvarchar(4000)
set @str=N'INSERT INTO e_subscribe_send_log_'+cast(@esl_id as Nvarchar(10))+N' (et_id, es_id, essl_code, essl_desc) VALUES ('+cast(@et_id as Nvarchar(10))+N','+cast(@es_id as Nvarchar(10))+N','+cast(@essl_code as Nvarchar(10))+N','''+cast(@essl_desc as Nvarchar(1000))+N''')'
exec(@str)

GO

[CrazyFor]

TRY:


CREATE PROCEDURE e_addnew_subscribe_send_log
@esl_id int,
@et_id int,
@es_id int,
@essl_code int,
@essl_desc nvarchar(2000)
AS
declare @str nvarchar(4000)
set @str=N'INSERT INTO e_subscribe_send_log_'+cast(@esl_id as Nvarchar(10))+N' (et_id, es_id, essl_code, essl_desc) VALUES ('+cast(@et_id as Nvarchar(10))+N','+cast(@es_id as Nvarchar(10))+N','+cast(@essl_code as Nvarchar(10))+N','''+cast(@essl_desc as Nvarchar(1000))+N''')'
exec(@str)

GO