Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««12345

Careful with table name alias Expand / Collapse
Author
Message
Posted Tuesday, May 18, 2010 12:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, July 14, 2010 10:34 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued 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
Posted Wednesday, December 22, 2010 4:07 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!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
Posted Tuesday, November 22, 2011 1:18 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Sunday, March 4, 2012 4:02 AM
Points: 660, Visits: 134
Now this is a good question....

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

Thanks for something practical and not another trick question that hides something.
Post #1209877
Posted Wednesday, March 21, 2012 11:23 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 5:36 AM
Points: 3,076, Visits: 3,193
I like questions from which I learn



Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1270374
« Prev Topic | Next Topic »

Add to briefcase «««12345

Permissions Expand / Collapse