CREATE PROCEDURE SPAnonymUserData
(
@Table NVARCHAR (64),
@Id INT,
@Name nvarchar(255)
) AS
SET NOCOUNT ON;
DECLARE @SQL NVARCHAR(4000);
DECLARE @ParameterDefinition NVARCHAR(4000);
SELECT @ParameterDefinition = ' @IdParameter INT,
@NameParameter nvarchar(255)';
SELECT @SQL = N' insert into ' + @Table + '([Id],[Name])
Values
(' + CAST(@Id AS nvarchar(max)) + ',' + CAST(@Name AS nvarchar(max)) + ')';
EXEC sp_executeSQL @SQL, @ParameterDefinition, @IdParameter = @Id, @Name=@Name;
如果我给定名称“ Name1”，则服务器使用“ Name1”作为列名....请帮助
请尝试在输入数据之前和之后插入单引号。
CREATE PROCEDURE SPAnonymUserData
(
@Table NVARCHAR (64),
@Id INT,
@Name nvarchar(255)
)
AS
SET NOCOUNT ON;
DECLARE @SQL NVARCHAR(4000);
DECLARE @ParameterDefinition NVARCHAR(4000);
SELECT @ParameterDefinition = ' @IdParameter INT,
@NameParameter nvarchar(255)';
SELECT @SQL = N' insert into ' + @Table + '
( [Id], [Name] )
values
(' +
CAST(@Id AS nvarchar(max)) + ' , ''' + CAST(@ShopId AS nvarchar(max)) + ''' ) ';
EXEC sp_executeSQL @SQL, @ParameterDefinition, @IdParameter = @Id, @Name=@Name;
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句