Common table expression can be used in select /insert /update statement for one time only, as next statement of defination only.

with small correction...

declare @lstr varchar(200)

declare @word table (tableName varchar (50))

set @lstr = 'select top 1 name from sysobjects'

insert @word

exec(@lstr)

select * from @word

🙂

If you can not use CTE you can replace the code by temp tables or table variables.:-)