Forum Replies Created

Viewing 15 posts - 121 through 135 (of 234 total)

  • RE: Triggers and Transactions

    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...

  • RE: Triggers and Transactions

    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....

  • RE: Creating indexes on computed columns

    Just another 0=1

  • RE: Simple LIKE with wildcard

    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....

  • RE: Round

    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=...

  • RE: one character of data

    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...

  • RE: Keeping Engaged

    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...

  • RE: Keeping Engaged

    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....

  • RE: How many partitions?

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

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

  • RE: Basic

    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...

  • RE: Basic

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

  • RE: Deprecated Features

    UMG Developer (8/4/2010)


    Nice question, thanks!

    But for the record it is spelled deprecated not depreciated.

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

    I had worse...

  • RE: T-SQL SQL 2008

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

    Nice equestion.

  • RE: Access variables values from Trigger

    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...

  • RE: Limited Features or Limited Time?

    My votes:

    Full featured product with limit on number of uses

    Hybrid - fullfeatured for at least one month, then limited

Viewing 15 posts - 121 through 135 (of 234 total)