How to write a query in T-SQL without a Select N'column' table with a column name?

Question

SQL

How to write a query in T-SQL without a Select N'column' table with a column name?
If it just Select N'column'shows

And you need a column name then take it out of it
Thanks for the answers. Very helpful)

Answer 1

select 'column' as column_name