@hugo: Yes, you couldn't deploy from a case sensitive dev environment to an case insensitive server.

Still I didn't understand why I should use case sensitivity in my...

Hugo Kornelis (5/1/2013)

I think Ron expected the ANSI_WARNINGS setting to cause errors. Either because of the implicit conversion of 12.5 to integer, or because of the string truncation.

However ...

1. Rounding...

Good question, and even better reference. Thanx!

Carlo Romagnano (9/16/2013)

---

No, the scope is to the end of the batch, here, you can reference @j-2 out of the loop.

declare @i int

set @i = 2

while @i...

:blush:

If I hadn't tried it out I would have gotten it wrong.

:blush: again...

...is this English grammar correct, by the way?

Hi, Orlando,

great article: Very good structured, easy to understand, good example! What I liked most was the "Disadvantage" section: I failed to find any disadvantages, and I am looking forward...

Would anyone admit that he is too tired to work smart?

:->

Good point, the article, especially for getting conscious of the state you're in.

I just miss one important consequence and some...

Works for me also, thx a lot!

Spent a lot of time on this one now...

:-/