Question

sqlserver存储过程语法错误的问题

CREATE PROCEDURE [ttt] @ta char(20) AS
select mem from ' + @ta + '
总是提示语法错误，请高手帮忙

Answer 1

CREATE PROCEDURE [ttt] @ta nvarchar(20) AS

exec('庆州胡select mem from '誉拦迹培+ @ta)

Answer 2

CREATE PROCEDURE [ttt] @ta nvarchar(20) AS

exec('迹培select mem from '庆州胡誉拦+ @ta)