Good Question but still I have doubts in some cases like:

SELECT ISNUMERIC('.+') -- Returns 0

SELECT ISNUMERIC('+.') -- Returns 1

SELECT ISNUMERIC (',\') -- Returns 0

SELECT ISNUMERIC ('\,') -- Returns 1

:ermm:

Dineshbabu (4/4/2013)

---

Really a great QotD. No matter whether the wording of question or answer options are wrong. It triggered a great discussion where everyone understood the behaviour of On &...

mamzy.rahman (4/4/2013)

---

hey guys

need some help with a query!!!

basically i have a table that has a list of learner with a number of aims. i want to do a query that...

Sorry Lon,

Changing the WHERE to AND will result in different output rows... that's...

L' Eomot Inversé (4/4/2013)

---

I like the question. Not of course the form and wording of the answers (|I won't say more than that as Hugo has covered it...

Hugo Kornelis (4/4/2013)

---

Great idea for a question, Kapil!

But ... (isn't there always a "but"?)

When I saw the question in the newsletter, I expected the answer options to be phrased in...

Danny Ocean (4/4/2013)

---

kapil_kk (4/4/2013)

---

Hi all,

I also thinks that the options are not well written... Sorry for that 🙁 ..

My point of concern was to to throw light on different behaviors...

Hi all,

I also thinks that the options are not well written... Sorry for that 🙁 ..

My point of concern was to to throw light on different behaviors of AND and...

When we have inbuilt function...

Lynn Pettis (4/3/2013)

---

kapil_kk (4/3/2013)

---

Hi all, I have created a sp in which I want to extract last identity value after doing insertion....

But its giving me error that @new_identity parameter...

Hugo Kornelis (4/2/2013)

---

No and yes.

No, because the working of LEN and DATA_LENGTH are not affected by this...

Good question :-):-)

:-P:-P

Ahhhhh........ I lost the chance to grab a lot of points 🙁

But I am doing only insertion not updation...Will it be good to use it only for...