Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select Syntax Question 1

Status
Not open for further replies.
xweyer

xweyer

MIS
Sep 7, 2000
140
US
I'm new to TSql and am trying to interpret a line of code which reads....

SELECT 'ASSET' Category,id, program,

"id" and "program" are fields from the source table but "Category" is not. So what is it? An alias of some sort?





 
Sort by date Sort by votes
That is a method of 'hard coding' data. Every record returned by the query will appear to have a column named Category with a value of ASSET.



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
SSMS question 1
Replies
4
Views
1K
Sana Shazadi
S
SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
854
SashaBuilder3
SashaBuilder3
leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
813
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Field types question
Replies
9
Views
611
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
SELECT TOP 1 of Each of a Group
Replies
5
Views
553
grnzbra
grnzbra

Part and Inventory Search

Sponsor

Back
Top