Viewing 15 posts - 346 through 360 (of 552 total)
honza.mf (5/14/2013)
Raghavendra Mudugal (5/14/2013)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
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...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
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"...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
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
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
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.)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
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...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
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.
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
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...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
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,...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
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...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
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...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
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?)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
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...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
May 3, 2013 at 2:37 am
good one, thank you for the post. 🙂
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
May 3, 2013 at 1:20 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;
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
May 2, 2013 at 12:13 am
Viewing 15 posts - 346 through 360 (of 552 total)