Viewing 15 posts - 346 through 360 (of 552 total)
honza.mf (5/14/2013)
Raghavendra Mudugal (5/14/2013)
May 14, 2013 at 5:00 am
Alex Fekken (5/14/2013)
Not sure and can't think of why one would use as "BETWEEN -1 AND -10" with "start" as the higher value in any practical case.
Depends on where you...
May 14, 2013 at 4:44 am
Really Good one, Hugo, thank you for posting (so basic and so much of valuable point)
(Not sure and can't think of why one would use as "BETWEEN -1 AND -10"...
May 14, 2013 at 1:51 am
WWDMark (5/10/2013)
Interesting one, had to use sp_help though as I wasn't 100% sure! 😀
+1
May 10, 2013 at 3:24 am
Good one, thank you for the post.
(so basic, and yet so important in our daily script writings and need to keep an eye on it.)
May 9, 2013 at 2:13 am
Hugo Kornelis (5/8/2013)
Mighty (5/8/2013)
The view definition is such that...
. What is it exactly why it...
May 8, 2013 at 7:18 am
Awesome, Tom. Thank you for the post.
(as soon as I saw the condition, "=ceiling..." i was sure ... it was you 🙂 )
Very smart question and explanation.
May 8, 2013 at 6:26 am
sknox (5/7/2013)
...I'm glad to see that that has not happened.
+1
(now people are getting smart and they are considering CI_AS as the default collation when not mentioned by author...
May 7, 2013 at 10:10 am
Hugo Kornelis (5/7/2013)
Raghavendra Mudugal (5/7/2013)
I guess, when we DISTINCT, it also sorts the data physically, so usage of additional ORDER BY is not needed
WRONG!!!!!!
This may or may not work correctly,...
May 7, 2013 at 8:02 am
Classic;
Thank you for the post, so simple and yet it keeps us busy getting it correct. 🙂
There is one SQL batch (a report data) where I used DISTINCT on all...
May 7, 2013 at 1:24 am
....
And finally, to Steve - I know we've discussed this before, and I know it won't happen, but I just have to ask again. Can you please, please, please get...
May 6, 2013 at 3:34 am
Good one, thank you for the Kick Start Post. 🙂
(well... long story short...) "damn!!!..." (where is my "learn sql in 21 hours for beginners" book?)
May 6, 2013 at 1:02 am
Toreador (5/3/2013)
Danny Ocean (5/2/2013)
Most of people don't know about it because it's not in use in any real scenario.
Sure it is, if the table contains other columns, all with defaults.
As...
May 3, 2013 at 2:37 am
YES; finally my powers are restored in my finnnngers (i mean i selected the right answer :-P)
thank you for the post, nothing can beat the classics;
May 2, 2013 at 12:13 am
Viewing 15 posts - 346 through 360 (of 552 total)