check data from @tablename sql

Drop Table if exists tablename

Declare @q nvarchar(max)='select * into tablename from '+ @TableName

EXEC sys.sp_sqlexec @q;