T-SQL with a added field

  • Thread starter Thread starter Himansu
  • Start date Start date
H

Himansu

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.
 
select name, id, "HHA" as company from test

Tim

Himansu said:
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:

* 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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Edited data record to be inserted as a new data record under the same PO number in Microsoft Access 0
extracting data 3
Mid column sum formulas with varied ranges to sum 17
Summing Criteria with Index - Match 3
Access Determine what query to run based on a checkbox 0
Move Column Values to Rows - THANKS in Advance 3
How to finding student Rank and How to upload bulk marks of each student at a time. 1
Access Page Header with merge field 0

Back
Top