插入数据的存储过程错误!!!,高的莫名其妙
存储过程内容如下
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
/**
* 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'。此处只允许使用常量、表达式或变量。不允许使用列名。