Viewing 15 posts - 406 through 420 (of 552 total)
Thanks for the question, Simply Nice 🙂
(we have like 250+ database on each principals where the structure of each database is same, only the data stored is different, hosted on...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 15, 2013 at 2:33 am
Thank you, Thomas for the question, was set nicely.
With all the information provided and the associated non SQL section - I did not use any of my intelligence (what I...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 12, 2013 at 1:37 am
Awesome question, Steve.
Never knew of this until now and while checking the BOL I came across the section "to edit the thesaurus file.." and in 2nd point it states;
If you...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 8, 2013 at 3:59 am
alex.d.garland (2/7/2013)
Hugo Kornelis (2/7/2013)
paul s-306273 (2/7/2013)
Steve - 0 points to you for creating a view using 'select *'...😛
So how should Steve have made a QotD about the dangers of select...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 7, 2013 at 3:17 am
Awesome QtoD, thank you Steve.
(was thinking if the 4th option will come true in future versions, would be cool, and then thought again.. setting auto to everything is not a...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 7, 2013 at 2:04 am
sipas (2/6/2013)
Raghavendra Mudugal (2/6/2013)
so, if no brackets then just start from L to R no matter what the operator is...
Almost... If there are no brackets, use BODMAS to work...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 6, 2013 at 6:28 am
Dineshbabu (2/6/2013)
Raghavendra Mudugal (2/6/2013)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 6, 2013 at 6:26 am
sipas (2/6/2013)
Toreador (2/6/2013)
archie flockhart (2/6/2013)
It can matter whather you do the multiply or divide first.
(12 / 3) * 2 will give a different answer to 12 / (3*2)
Yes, but...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 6, 2013 at 5:57 am
archie flockhart (2/6/2013)
We learned the mnemonic as "BOMDAS" and also that the Multiply and Divide, and the Add and Subtract, were pairs of items of equal precedence.
Something like Bo[md][as]...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 6, 2013 at 2:52 am
Hugo Kornelis (2/6/2013)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 6, 2013 at 1:31 am
Gary Stacey (2/6/2013)
I'd applied BODMAS to the 4 statements so I figured it was a different answer. Thought my reasoning was sound, so I checked the...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 6, 2013 at 1:26 am
Good one. 🙂
(after lahhhhhhhhot of thinking and breaking them bit by bit finally (i think) understood the flow.. but i cheated by executing the code and picking the answer... NOT-:cool:)
the...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 6, 2013 at 1:25 am
Dineshbabu (2/4/2013)
...Is there any collation setting to affect the result of today's question ?
(well, to my knowledge understanding, I don't think precedence change according to the collation, and I think...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 5, 2013 at 1:02 am
Awesome, thank you Tom.
(up until now never knew this, all the time i used simple case.... 🙁 even though BOL has mentioned this clearly i never looked it properly :-P...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 5, 2013 at 12:43 am
Viewing 15 posts - 406 through 420 (of 552 total)