Viewing 15 posts - 316 through 330 (of 658 total)
L' Eomot Inversé (1/30/2013)
Nice question, but it's rather startling how many got it wrong. ...
January 30, 2013 at 5:08 am
paul s-306273 (1/18/2013)
In my naivete I'm thinking 'so what?'.Is there a relevance to this?
That was my reaction as well. Especially as actually running the code gives different results.
January 18, 2013 at 2:53 am
chgn01 (1/17/2013)
Aliases are not for columns where there is only one column possible.
In the same way that you don't have to specify a column list when inserting into a table...
January 17, 2013 at 10:05 am
What would be a good use of this function?
Why wouldn't you just add a lookup table containing the index and description, and join to that?
So that any changes required to...
January 14, 2013 at 7:30 am
Hugo Kornelis (1/11/2013)
I actually have a suggestion on Connect to add this feature - feel free to add your vote if you agree. Link: https://connect.microsoft.com/SQLServer/feedback/details/299231/add-support-for-ansi-standard-row-value-constructors
Done.
Obviously not high priority as they...
January 11, 2013 at 4:27 am
Hugo Kornelis (1/11/2013)
NOT IN can only be used in limited cases. The comparison condition must be multi-column
Do you mean 'the comparison condition cannot be multi-column'?
That's one of the ways where...
January 11, 2013 at 3:56 am
sestell1 (1/10/2013)
Toreador (1/10/2013)
If you are talking about moving left to right in BODMAS, you will not get the correct answer. Take for instance 4 - 2 + 2.
Moving left...
January 10, 2013 at 8:16 am
sestell1 (1/10/2013)
Toreador (1/10/2013)I think there's a common misconception that each letter of the acronym is a higher priority than the next, instead of being pairs of operations.
That's true, but if...
January 10, 2013 at 6:52 am
chgn01 (1/9/2013)
Aliases are not for columns where there is only one column possible.
Whyever not?
January 9, 2013 at 9:46 am
DavidBridgeTechnology.com (1/9/2013)
When is New Years Eve anyway?
February 9th 😉
January 9, 2013 at 7:42 am
Saw the question title and the SQL and thought this would be a useful question about joins.
Was about disappointed to find it was a yes/no question rather than about the...
January 9, 2013 at 6:21 am
Viewing 15 posts - 316 through 330 (of 658 total)