Careful with table name alias

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 Roshan Joseph » Careful with table name alias

45 posts, Page 5 of 5

«««1 2 3 4 5

Careful with table name alias

Rate Topic

Display Mode

Topic Options

Author

Message

anil.sharma 8548

Posted Tuesday, May 18, 2010 12:12 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, August 12, 2010 5:03 AM
Points: 2, Visits: 1

Yes, u can use like that
Select [flag ='y'].some_data from [where] [flag ='y']

Post #923308

forjonathanwilson

Posted Wednesday, July 14, 2010 10:34 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, September 14, 2010 8:24 AM
Points: 69, Visits: 33

saranya.megalai (5/14/2010)

if flag is alias then can we use next statement like

select [flag='y'].some_data from [where]?

actually:

Select [anything].some_data from [where] [anything]

Post #952518

jaganmohan.rao

Posted Wednesday, December 22, 2010 4:07 AM

SSC Eights!

Group: General Forum Members
Last Login: Monday, March 25, 2013 4:03 AM
Points: 850, Visits: 71

Good question.

Regards,
Jagan.

Post #1038160

terrykzncs

Posted Tuesday, November 22, 2011 1:18 AM

SSChasing Mays

Group: General Forum Members
Last Login: Sunday, March 04, 2012 4:02 AM
Points: 660, Visits: 134

Now this is a good question.... BigGrin

From now on I will be more careful when using [] in my code... w00t

Thanks for something practical and not another trick question that hides something.

Post #1209877

IgorMi

Posted Wednesday, March 21, 2012 11:23 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 8:28 PM
Points: 1,906, Visits: 1,522

I like questions from which I learn

Post #1270374

« Prev Topic | Next Topic »

45 posts, Page 5 of 5

«««1 2 3 4 5

Permissions