Viewing 15 posts - 1 through 15 (of 20 total)
YEAH! Got it right! Now, off to buy a Lotto ticket!
December 21, 2005 at 6:28 am
I don't think we really have enough info to decide the "right" answer. Even the referred article hedges its bets. One type has limited precision. The other has greater precision,...
November 23, 2005 at 2:56 am
The question specifically states that you are on the clients site (so you aren't available back at base to do any reconfiguring) and that you're using a clients PC, so...
October 12, 2005 at 2:53 am
I'm sorry, we'll have to order them. No call for that size, you see.
October 7, 2005 at 6:01 am
I agree it's important to be aware of DST - but the amount by which the start date moves in one country can't be of much importance to anyone. You...
October 7, 2005 at 2:57 am
As you'd expect on a VARCHAR. LEN is a useful funcion to use on a VARCHAR, but not really on a CHAR.
August 23, 2005 at 10:13 am
I would imagine Sybase returns 20 because that's the length of string you get back. A CHAR(20) string will be padded with spaces to make it 20 characters long, eg...
August 22, 2005 at 8:21 am
OK, I admit it, I got it wrong. But "Explanation (from BOL): LEN() returns the number of characters of the given string expression, excluding trailing blanks." That's just plain nuts!
Actually,...
August 22, 2005 at 2:06 am
Yes, I wondered that, but there didn't seem to be be an appropriate option, e.g. "None of these queries will extract the data from this document" would have got my...
June 22, 2005 at 6:24 am
I do not claim to be an XML guru, but surely the document is not valid? The <managerEmail> tag is closed by </managedEmail>.
June 22, 2005 at 2:51 am
3 (C). XQUERY is a query language to extrat data from XML documents.
Is extrating data anything like extracting it?
June 15, 2005 at 1:31 am
Radio 4 broadcast the first series of six episodes, then a one-off Christmas special, then some time later another five episodes. The TV series, broadcast in early 1981, covered the...
May 4, 2005 at 1:44 am
I don't use LiteSpeed, so I guessed: the only decision I had to make was "Does the person who wrote the question like LiteSpeed or not?"
March 8, 2005 at 3:31 am
Am I missing something? I'm a real SQL newbie (hey, some days I can't even spell SQL!) but that looked really simple. I couldn't see the catch, so I went...
November 4, 2004 at 2:29 am
A, B and C? I got it right, so it was clear what you meant, but a little proof-reading goes a long way...
September 29, 2004 at 2:56 am
Viewing 15 posts - 1 through 15 (of 20 total)