CREATE TABLE bbb(
ccc VARCHAR(100) NOT NULL
)
insert into bbb(ccc)
select FZDY13,* from T_HR_PersonTechPost
declare @s varchar(100);
declare @fname varchar(100);
set @fname = 'FZDY'+'14';
set @s = 'insert into bbb(ccc) select top 1' + @fname + ' from T_HR_PersonTechPost' exec(@s) -- 成功 exec sp_executesql @s -- 此句正确
print @s
select * from bbb