Nobody does, I think. 🙂

Probably for historical (hysterical?) reasons.

But this difference has already been the subject of many QotD's,...

da-zero (10/4/2010)

---

Good question and thanks to Oleg for the more detailed explanation.

@nakul: no excuses about having no time to do the detailed reasoning 🙂 Post your question a few days...

john-645829 (10/1/2010)

---

I have a query that in fact uses ORDER BY but not on enough columns to make each row unique on these columns. Someone else has a similar query,...

taylor_benjamin (10/2/2010)

---

Than you for responding to my question.

Respectfully I disagree with your correct solution.

Losing a constraint of not null simply to modify the column length quickly is not a...

Tom.Thomson (10/1/2010)

---

nice simple question.

But I'm worried that MS thought it useful to increase the number of non-clustered indexes allowed on a table from 248 to 999: that presumably means that...

Thanks, Tommy! I don't have SQL2000 available to test, so I had to go by the documentation. And the description of the effects of ROLLBACK in a trigger is word...

tommyh (10/1/2010)

---

Also good that Microsoft change the way that SQL handles this. In 2000 you wouldnt have a clue that your insert just got shafted. Atleast in 2005 and 2008...

:laugh: Good catch, Ashwin. I think the documentation needs to be expanded to list dropping the constraint as an exception to this rule. Maybe you can submit this as a...

Recursive CTE'sare an invaluable tool when working with hierarchic data (like employee/supervisor relations,...

David Data (9/28/2010)

---

OTOH I designed our ETL system with [Postcode] [nvarchar](10) and then had to change it when I found records with postcodes like 'If out please leave by back...

If you use

select i+1, char(i), isnumeric(char(i)) from l where i < 127

Then...

That's probably because all products had already implemented their own syntax for...

jlennartz (9/27/2010)

---

The discussion usually answer my questions but not this time. Doesn't "isnumeric(char(32)) as n" return 0? And if so wouldn't "select sum(n) from l" also...

wware (9/27/2010)

---

Experimenting with the code in this question, I am getting different results from two SQL 2008 servers. One evaluates '\' as numeric. The other doesn't. They...

tommyh (9/27/2010)

---

Hugo Kornelis (9/27/2010)

---

tommyh (9/27/2010)

---

I dont agree with your arguments either. A string is either a number or its not. Not depending on what you try and convert it to....