Hugo Kornelis (11/9/2010)

---

If SQL Server would observe the national Greece calendar, it should also support the Bahá'í, Buddhist, Chinese, Eastern Christian, Ethiopian, Hebrew, Hindu, Indian, Iranian, Islamic, and Thai Solar...

SanDroid (11/5/2010)

---

Hugo Kornelis (11/5/2010)

---

If the default language of your server happens to be, for example, British English, you'll get 1 as your answer. Same for German, Dutch, French, and...

Most of complainers: The problem is not dd/mm/yyyy against mm/dd/yyyy as both combinations are inserted (First of July and Seventh of January).

Problem is in yyyy/dd/mm against yyyy/mm/dd. And both...

Hugo Kornelis (11/5/2010)

---

(I used an educated guess - in my experience, over 90% of the code that does not cater for international use comes from the US, so I picked...

Yes, there are different cultures with different dateformats. Not only strange countries from the east of Europe!

The different order in writing dates in UK and USA was used as a...

Toreador (10/15/2010)

---

Not at all.

But the answer as given doesn't depends on SQL, but on how you interpret the phrase "the status bar"....

Thanks, Hugo. You have built great reputation here.

And the others: Don't complain. The question and answers are OK. Yes, it's tricky. Do you like to obtain point without thinking?

I will not talk about the answers. It's clear for me: the main window status bar no, the query editor window yes.

It's a nice option I didn't know about. I'm...

Tom.Thomson (10/5/2010)

---

Nice question.

But is there something wrong with the documentation? The BoL page referenced states

@@TRANCOUNT is incremented by one when entering a trigger, even when in...

Oleg Netchaev (10/1/2010)

---

honza.mf (10/1/2010)

---

Thank you Oleg, well done.

It has only one little bug: You start new transaction allways. It is unsafe as you can nest several transactions.

I prefer in such...

Oleg Netchaev (10/1/2010)

---

Hugo Kornelis (10/1/2010)

---

Exactly what change are you refering to? As far as I know, the effect of ROLLBACK in a trigger in current versions is the same as...

Rich-403221 (10/1/2010)

---

I found the question a little misleading due to the fact that you are assigning the trancount to a variable prior to the insert. If you inserted @@trancount DIRECTLY...

Because the trigger allows only even numbers and 3 is...

One thing I haven't counted with, when I was preparing the question.

It's a hell, versions, collations, options,...

Hugo Kornelis (10/1/2010)

I develop a code generator that offers much more constraints that just the standard SQL Server constraints. Triggers are used to check modifications against these constraints. If violations...