sqlserver 存储过程 增加

CREATE PROCEDURE [dbo].[InsertMessage](
@strTable varchar(50),         --表名
@strValues nvarchar(1000),     --要插入的数据（用英文逗号分隔）,如果是字符串类型，需加单引号
@only_field varchar(20)=NULL,  --唯一性字段(列名)
@only_value varchar(20)=NULL,  --唯一性字段值
@msg nvarchar(50)=NULL         --错误消息
)
as
BEGIN SET NOCOUNT ON;
declare @sqlString varchar(5000);

IF @only_field is not null
    begin
        declare @p int;                    --查询唯一性结果
        declare @sql nvarchar(1000);       --拼接查询sql字串
        set @sql=‘SELECT @p=count(1) FROM ‘ +@strTable+‘ WHERE ‘ +@only_field+‘=‘+@only_value;
        exec sp_executesql @sql,N‘@p AS int OUTPUT‘,@p OUTPUT
    
        if @p > 0
            begin
                raiserror(@msg ,16,1)
                return
            end
        else
            begin
                set @sqlString = ‘insert into ‘+@strTable+‘ values (‘+@strValues+‘)‘;
                exec(@sqlString);
            end
    end
ELSE
    begin
        set @sqlString = ‘insert into ‘+@strTable+‘ values (‘+@strValues+‘)‘;
        exec(@sqlString);
    end
END

--execute [dbo].[InsertMessage] ‘base._Member‘,"0,2,getdate(),0,1,‘4445‘,‘654321‘,‘654321‘,N‘邹柯00‘",‘AcctNbr‘,‘4445‘,N‘会员卡号已存在,不能重复添加!‘
--execute [dbo].[InsertMessage] ‘base._Member‘,"0,2,getdate(),0,1,‘4445‘,‘654321‘,‘654321‘,N‘邹柯00‘",NULL,NULL,NULL