Returning default values in SQL queries

Question

I have a query in SQL where I select a couple of attributes from a few tables. However, I also need to return default hardcoded values such as 'HardCodeValue' in the results. I am not querying a table/column however for this but I do want a column in the results set called 'hardCodeDefaultValueColumn' with this hardcoded default value for every row in th result set.

Is there any way I can do this in SQL?

Thanks

Answer 1

Just add 'HardCodeValue' as hardCodeDefaultValueColumn in your SELECT, among the other columns selected, like so:

SELECT ..., ..., 'HardCodeValue' as hardCodeDefaultValueColumn
FROM ...