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)