Grig, I have often thought the same. There is lots of TSQL that is dynamically driven though and for this they use the column ID's extracted from the schema so the actual name becomes irrelevant. However, I have been caught on a number of occasions with misspelt alias names and it can be really annoying. If you look at most of the commercial Builders for views etc then they don't allow duplicates but I guess this is so as to fit in with the other mainstream DB's.
Dave C -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Grigore Dolghin Sent: 06 August 2010 09:26 To: [email protected] Subject: [NF] Do I miss anyhting? Can any of the MS SQL gurus here explain to me why the hell MSSQL Server allows this: Select Column1 As Name, Column2 As Name, Column3 As Name The point is you can have multiple columns having same name in output. I just don’t understand who the heck needs this. If you later need to access one of the columns by name, you’re pretty much f*cked up. Is there any logical explanation for this? --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
