tommyh (10/1/2010)

Running the code under 2000 all i get is

(1 row(s) affected)

under 2005 and 2008 i get

Server: Msg 3609, Level 16, State 1, Line 1

The transaction ended in the...

tommyh (10/1/2010)

---

However i still wonder in what circumstances that rolling back a transactions inside a trigger is a good thing. Isnt anything i have ever felt the need to use....

Just another 0=1

Tom.Thomson (9/22/2010)

---

A beautiful question, which may have made some of the backwoodsmen notice that there are collations other than the one which fits US ASCII perfectly and fits nothing else....

tommyh (9/16/2010)

---

Nice question. Though the explanation isnt entirely accurate. Its not rounded, its truncated.

If the question had been, lets say

declare @r decimal(5,2)

set @r= round(5/3.2,1,3)

select @r

Then we would...

With char(n) where n > 1 you must take care of ANSI PADDING settings. It's another story.

nchar is "better", it always behaves as set to ON.

From this point of...

For the "make work fun" I have a simple example. I suggested my boss during one of our meetings to create a new category of tasks "Funny for developper". And...

I was at one position in one company from 1992 to 2002.

After that I am on other position in other company. The company was renamed, but it's that same one....

The query without [font="Courier New"]group by[/font] looks strange.

In case the table is populated, it must return millions of rows.

Nadrek (8/9/2010)

---

For anyone that says Unicode, I ask, which one?

UTF-8

UTF-16 (BE by default)

UTF-16BE

UTF-16LE

UTF-32 (BE by default)

UTF-32BE

UTF-32LE

Or, perhaps, late 90's (very archaic) implementations like UCS-2 (used in...

ASCII, ANSI, EBCDIC are out of date. Unicode rulez 😀

I think the typo in title is not such a great problem. Both words exist.

I had worse...

+= or *= are quite easy, but |= or even ^= wanted a little thinking on bitwise arithmetics.

Nice equestion.

Nice idea. But we have context info already used for other data. It is possible to this data into a variable, use this trick and restore them. I'm afraid of...

My votes:

Full featured product with limit on number of uses

Hybrid - fullfeatured for at least one month, then limited