关于Exec的一个问题?
DECLARE @Class as char(10)
DECLARE @StrSpdm AS CHAR(15)
SET @StrSpdm = '0011%'
Set @Class = 1
EXEC('SELECT Spdm,Spmc,Spgg,Spcd,Xsjg'+@Class+', Mindw,Cs,Memo FROM Spzl WHERE SPDM LIKE '''+@StrSpdm+''' ORDER BY SPDM')
以上查询什么东西都没有,但是用以下语句就可以,怎么办?
EXEC('SELECT Spdm,Spmc,Spgg,Spcd,Xsjg'+@Class+', Mindw,Cs,Memo FROM Spzl WHERE SPDM LIKE ''0011%'' ORDER BY SPDM')--就是替换了@StrSpdm变量