I thought this wouldn't work because I assumed 2005 worked the same as 2008. I was surprised to see that I was wrong. I wanted to see it work in...

I did a little research on this and found that this was suggested on the MS Connect site on 7/7/2005 and 4/22/2008. Microsoft said it was too late to include...

Christian Buettner (8/10/2009)

---

Hi Kevin,

I think that is not true.

Try select isnumeric('$$') for example.

It will evaluate to false, although this character ($) was no issue in your previous example.

The reason why...

isnumeric is just evaluating valid characters.

This will produce 1 also

select isnumeric('-$,')

Michael Poppers (7/10/2009)

---

I think Mr. Williams meant...

Another article that describes this in more detail.

http://support.microsoft.com/kb/310421

-Kevin Williams

This question to too vague. Best for what?

Well I got it wrong because I was not familiar with the except operator. But is MDX considered T-SQL?

How about using the replace() function when selecting the data to export? Here is an example.

declare @test-2 varchar(8000)

select @test-2 = 'test

test

test'

select @test-2

select replace(replace(@Test, char(10), ''), char(13), ' - ')

Lynn Pettis (3/23/2009)

---

kevin.l.williams (3/23/2009)

---

I know why the null value is not returned but I am puzzled by the explanation.

"Since col2 is used in the WHERE clause, the output does not...

I know why the null value is not returned but I am puzzled by the explanation.

"Since col2 is used in the WHERE clause, the output does not include the corresponding...

natet (3/20/2009)

---

Regardless of the settings, shouldn't the Start Tran had implicitely Committed the previous activities? and returned 1 and 2?

After all, the Start Tran started a new Logical Unit...

At first I was confused about why it would not return the already committed data and I did an experiment by changing the code. Very interesting question. Thanks!

--first window

CREATE TABLE...

Cliff Jones (11/14/2008)

---

I am not sure why they changed the scripting so that it does not include the 'GO'? It is such a subtle little change that has caused...

Thank you very much for this QOTD! I have been using COALESCE only when I was working with more than two values and was totally unaware of this behavior of...