Forum Replies Created

Viewing 15 posts - 436 through 450 (of 658 total)

  • RE: TRUNCATE TABLE and ROLLBACK TRAN

    Stewart "Arturius" Campbell (2/6/2012)

    Wonder when this was changed?

    Granted I haven't worked in Oracle itself since 7b...

    It was always the case in Oracle 7 and before as well (ie when I...

  • RE: XML to Relational

    L' Eomot Inversรฉ (1/27/2012)


    I have a question arising from the discussion: Why are references to parent nodes not liked?

    I was going to ask the same thing. I do a...

  • RE: Hashing

    Nice question, but the documentation linked to doesn't really explain anything!

  • RE: billy-yons and billy-yons of rows

    I hope those who answered 32767 were joking!

  • RE: Multiple Inserts

    Hugo Kornelis (1/17/2012)


    A good question, and it's hard to see how anbody could contest the correct answer.

    How long before someone complains that the correct answer is an error message saying...

  • RE: Query Plan Execution Order

    Sergiy (1/12/2012)


    Hugo Kornelis (1/12/2012)


    I think the problem is lingual.

    "Is executed" can have two meanings.

    1. Present tense, passive form - the code is invoked. Can be compared to running "EXEC MyStoredProc"...

  • RE: Numbers

    Hugo Kornelis (1/4/2012)There is no logic in this!

    describes the IsNumeric function in a nutshell ๐Ÿ˜‰

  • RE: Numbers

    The key phrase was "conversion from string to money or smallmoney"

    select cast('.' as money)

  • RE: Exact and Approximate

    Frank Hamersley (1/4/2012)


    How weird stuff like this survives in a commercial offering beggars belief (well mine if no-one elses)!

    I'm with you! It baffled me when I first came across it,...

  • RE: Using SP_

    Nice question, but not sure about the explanation. Surely the crucial point is that object_id('sp_mytable') is null, even though a select against that table recognises it (and a drop would...

  • RE: Variant order 1

    KWymore (11/30/2011)


    I am curious how many out there are utilizing sql_variant and under which circumstances?

    I've used it for generic audit tables, where we store something like table name, column name,...

  • RE: Variant order 1

    Hugo Kornelis (11/30/2011)


    To me, it was immediately obvious that the v3=v2 / v2=v3 error was a mistake made when entering the question and not a deliberate trick.

    Same here, but that...

  • RE: DATETIME Puzzle

    A very easy question, unless you temporarily forget how to count :blush:

  • RE: Table space usage 1

    Hugo Kornelis (11/9/2011)


    So it is not only, as you say, reasonable to assume that the question is about space for the table being discussed - it is explicitly stated!

    That still...

  • RE: Network Protocals

    Koen Verbeeck (11/6/2011)


    TCP/IP needs a network adaptor. Isn't that hardware as well? ๐Ÿ˜›

    And shared memory requires sufficient memory to share ๐Ÿ˜‰

Viewing 15 posts - 436 through 450 (of 658 total)