sql存储过程中加引号

小程序：扫一扫查出行
【扫一扫了解最新限行尾号】
复制小程序

ALTER PROCEDURE [dbo].[SaveTerminaInfo]
@TerminaNo NVARCHAR(50),
@Name NVARCHAR(50),
@Value NVARCHAR(500)
AS
BEGIN
DECLARE @Sql NVARCHAR (MAX)
SET NOCOUNT ON;

if NOT exists(select * from syscolumns where id=object_id('终端信息') and name=@Name)
BEGIN
SET @Sql = N'ALTER TABLE 终端信息 ADD ' + @Name + ' NVARCHAR(50)';
EXEC(@Sql);
PRINT @Sql;
END

SET @Sql = N'UPDATE 终端信息' + ' SET '+ quotename(@Name) +' = ' + ''''+ @Value + '''' + ' WHERE 编号' +' = ' + ''''+ @TerminaNo +''''
EXEC(@Sql);
END
GO

执行如下：

EXEC [dbo].[SaveTerminaInfo]
@TerminaNo ='31',
@Name='工号',
@Value='syl'