SELECT (Transact-SQL)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by jrtupa » SELECT (Transact-SQL)

34 posts, Page 4 of 4

«««1 2 3 4

SELECT (Transact-SQL)

Rate Topic

Display Mode

Topic Options

Author

Message

Danny Ocean

Posted Monday, October 29, 2012 6:39 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:51 AM
Points: 1,085, Visits: 1,166

kapil_kk (10/25/2012)

One question, I am confused on this...

select ID, name name from person

select ID ID, name name from person

Both these statements dont give any error message and run successfully...
wht is it so?

Hi kapil,

1st statement :-
it's showing that you are giving the alias column name to column 2(name). I can also right this like:-
select ID, name as [name] from person
or
select ID, name as [Column_2] from person

2nd Statement :-same thing happen in 2nd statement.

Check below statement. have fun

select '--------------------' as TT
select 233 as '____________'

Thanks
Vinay

Keep Learning - Keep Growing !!!
http://growwithsql.blogspot.in

Thanks
Vinay Kumar

Post #1378222