Dynamic SQL Excute

declare @tablename char(10)
declare @columnname char(10)
set @tablename='myTable'
set @columnname='myColumn'
execute('select * from ' + @tablename + ' order by ' + @columnname)