-1

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

DonalDraper
  • 5
  • 1
  • 4

1 Answers1

0

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

SELECT ..., ..., 'HardCodeValue' as hardCodeDefaultValueColumn
FROM ...
rikyeah
  • 1,896
  • 4
  • 11
  • 21