如何给存储过程的变量加单引号

Question

ALTER PROCEDURE [dbo].[FM_GuestBookRead]
@TableName Nvarchar(50),
@PostIp varchar(100)
AS
BEGIN
Declare @strSQL Nvarchar(200)
Set @strSQL='Select PostDate from '+ @TableName +' where postip='''+@PostIp+''
Execute(@strSQL)
END

想要给postip加单引号，但总提示说引号不完整

Answer 1

    Set @strSQL='Select PostDate from '+ @TableName +' where postip='''+@PostIp+''''