Viewing 15 posts - 211 through 225 (of 264 total)
Sorry - I hadn't noticed the original date. But this is clearly an Oracle query and pointing the guy to BOL is really no help at all.
April 5, 2011 at 9:44 am
LutzM (3/29/2011)
Edit: You also might ask for clarification what RDMS this class is about...
Question 7 gives it away, and it ain't this one;-)
I see you spotted the "twin post"...
April 5, 2011 at 8:58 am
I tried running the code and an error message popped up saying
"Your approach to SQL is wrong. BIT flags are things we left behind in assembly language. " 😉
March 30, 2011 at 3:27 am
It looks as though that's a bit of a "spam" page. There's no evidence that the product actually exists, just an "Enter your email address and we'll be in touch"...
March 25, 2011 at 5:19 am
Good code, Geoffrey. Glad to see it does not discriminate on grounds of looks, age or indeed gender. Still, as it gets close to closing time even a DBA will...
March 15, 2011 at 11:36 am
11/11/11 is also my birthday 😉 But I'll only be 11 if you work in base 50 🙁
That consecutive primes thing really IS interesting!
March 10, 2011 at 9:07 am
I'm a bit like that. I live in the UK where tomorrow's date may be written 11311. Not only is that palindromic, it's also a prime.
March 10, 2011 at 8:29 am
Just thought of another one:
What did Bill Sykes's girlfriend say when she put her coat on?
SET NANCY_PADDING ON
(Sorry - if you haven't read Oliver Twist that makes even less sense).
March 7, 2011 at 5:31 am
Yes, you just need to prefix it with "dbo." then it will be recognised.
February 25, 2011 at 10:33 am
Thanks, both.
I see what you mean but it does look as though both of these are very much row-based. Perhaps, given that the value of record(n) always depends on the...
February 24, 2011 at 10:16 am
Not a patch on Kinky Boots by Patrick Macnee and Honor Blackman. Not only did the song contain a reference to "sexy little schoolgirls" but it also suggested that boots...
February 23, 2011 at 10:36 am
Unfortunately I didn't get onto pints until around 1979 by which point they had gone up to a massive 34p each. But yes, the musical taste had also improved by...
February 23, 2011 at 10:20 am
crookj (2/22/2011)
Put the Lime in the Coconut....Joe
I remember buying that in Boots with my 40p pocket money. I would say thanks for the memory but I was kind of pleased...
February 22, 2011 at 10:42 am
DATENAME() is fine for SQL Server 2005 and later. However the article stated that it was for SQL Server 2000 so is of use to those of us working on...
February 21, 2011 at 4:15 am
It seems to be a bug associated with the Facebook "Like" button on the page and IE8. Hopefully it's been fixed now but if you Google it you'll find that...
February 7, 2011 at 4:47 am
Viewing 15 posts - 211 through 225 (of 264 total)