Cool approach for dynamic columns,

How can column names added dynamically instead of hardcoding it!

Is it possible via a sysname data type or is it only possible via dynamic sql.

regards Christian