Te recomendaria hacerlo de esta forma:
Código SQL:
Ver originalCREATE PROCEDURE miprocedure
@idioma AS VARCHAR(3)
AS
DECLARE @query AS nvarchar(MAX)
SET @query = 'select mitext_'+@idioma+', mikey_'+@idioma+' from tabla where miId = 25'
EXEC sp_executesql @query