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. It should be...

da-zero (9/27/2010)

---

+ / * - % are arithmetic operators, not numbers. So...

But you can of course add a WHERE clause to exclude the identical rows (like the final example, where small differences were excluded - change the requirement to an exact...

tommyh (9/27/2010)

---

da-zero (9/27/2010)

---

Good question, although I seem to remember that I've seen similar ones.

But I don't think that considering scientific notation as numeric is stupid. 2e1 is just another way...

tommyh (9/26/2010)

---

<rant>

Yeah... like total crap. Its borderline useless. Just to further demonstrate that.

select isnumeric('2e1')

This...

Rune Bivrin (9/24/2010)

---

I have this vague recollection that one of the "gurus" argued that the concept of PRIMARY KEY should have been left out of the standard on the grounds...

andy.brown (9/24/2010)

---

Really?...

tommyh (9/23/2010)

---

Have to agree with UMG Developer. The "Multiple identifier columns" shouldnt be part of the answer for 2 reasons.

1. Its not part of MS recommendations (atleast not on the...

Rune Bivrin (9/24/2010)

---

It's back to avoiding unneccesary NULL:s. If you need them by all means use them. Just make sure that you have good a motivation why a column should...

If the distinction between "empty string" and...

Rune Bivrin (9/24/2010)

---

However, looking the table in the question I'd probably remove the NULL-ability on the cell phone numbers. Nullable VARCHAR often doesn't make sense. Particularly when they are entered...

UMG Developer (9/23/2010)

---

I agree that OrderRefNo is an identifier, but if you look at my comment I was saying that OrderNo is not an identifier:

OrderNo INT NOT NULL IDENTITY(1,1),

So there...

I agree with UMG developer about the multiple identifier. I already had this option checked before deciding to check BOL first. I disagree with him about the missing identifier -...

It would be far worse if the inner transaction...

ROLLBACK...