举一个Northwind的例子。
DECLARE
@m_LastName
nvarchar
(
20
)
DECLARE @Sql varchar ( 256 )
SET @m_LastName = ' Fuller '
SET @Sql = ' SELECT * FROM Employees WHERE LastName= ' + char ( 39 ) + @m_LastName + char ( 39 )
EXEC ( @Sql )
DECLARE @Sql varchar ( 256 )
SET @m_LastName = ' Fuller '
SET @Sql = ' SELECT * FROM Employees WHERE LastName= ' + char ( 39 ) + @m_LastName + char ( 39 )
EXEC ( @Sql )
注意,要加上char(39)就可以了。