T-SQL with a added field
Hello everyone,
Anyonme know how to add a field to a query? I want to add a field with the
same data in all rows.
Example:
select name, id, company
from test
* There is no company field in the test table, but I want to add it to my
result with all company data equal to HHA.
Any help will be greatly appreicated.
--
Thanks,
Himansu
|