Forum Replies Created

Viewing 15 posts - 1,576 through 1,590 (of 3,348 total)

  • RE: Using a column name in a COUNT function

    From the article:

    You know that doing COUNT(*) on a table with a lot of columns and a lot of rows can take a lot of time and memory.

    Actually, no. I...

    October 17, 2013 at 1:23 pm

    #1659475

  • RE: Transaction

    marcia.j.wilson (10/16/2013)

    What would be some real-life situations in which you would use nested transactions?

    I have not seen any practical use cases for direct nesting of transactions in a single code...

    October 16, 2013 at 4:25 pm

    #1659092

  • RE: Transaction

    L' Eomot Inversé (10/16/2013)

    I'm quite horrified to see people claiming that Hugo is wrong, that these records really were inserted into the table, and using dirty read to support that...

    October 16, 2013 at 4:12 pm

    #1659090

  • RE: ISNUMERIC(varchar)

    ronmoses (10/15/2013)

    Hugo Kornelis (10/15/2013)

    ISNUMERIC returns 1 if the input can be converted to a numeric data type. It doesn't bother to tell you which data type.

    I've yet to discover what...

    October 15, 2013 at 2:54 pm

    #1658721

  • RE: ISNUMERIC(varchar)

    Dhruvesh Shah (10/14/2013)

    Good question. Any one know why it returns 1 for some/most of special characters?

    ISNUMERIC returns 1 if the input can be converted to a numeric data type. It...

    October 15, 2013 at 2:28 pm

    #1658710

  • RE: Transaction

    marlon.seton (10/15/2013)

    David Burrows (10/15/2013)

    Hugo Kornelis (10/14/2013)

    Yes, technically the rows were inserted and then rolled back. But from a logical point of view, the inserts never happened. Which makes the answer...

    October 15, 2013 at 1:22 pm

    #1658675

  • RE: Transaction

    Good question, and a good additional link posted by raulggonzalez - I was already getting ready to jump in with additional explanation, but I don't see the need after reading...

    October 14, 2013 at 11:23 am

    #1658316

  • RE: Field Lengths

    I almost got it wrong because of miscounting the number of extra columns. Was looking for a "10" answer in the wrong position. The only reason I ended up getting...

    October 11, 2013 at 3:40 pm

    #1658031

  • RE: NTILE

    jfgoude (10/1/2013)

    I wonder why Hugo did not answer L'Eomot, is he ill ?

    If Tom asked me a question in this topic, I overlooked it. I still don't see it now....

    October 9, 2013 at 2:25 pm

    #1657317

  • RE: Try.. Catch..

    L' Eomot Inversé (10/9/2013)

    It would be nice to know what the real reason for excluding those statement is, and whether it has any validity or is just silliness, because if...

    October 9, 2013 at 2:20 pm

    #1657316

  • RE: CTE

    L' Eomot Inversé (9/27/2013)

    Well, the syntax definition in BOL

    BOL page

    BEGIN

    { sql_statement | statement_block }

    END

    seems to make it quite clear that if you write...

    September 27, 2013 at 11:25 am

    #1654148

  • RE: CTE

    SQLRNNR (9/26/2013)

    Mr. Kapsicum (9/24/2013)

    but what about ;(semi colon) of WITH ?

    i guess, it should generate an error? :discuss:

    semi-colon ( ; ) is a statement terminator.

    It is not required to begin...

    September 27, 2013 at 12:19 am

    #1653862

  • RE: Dynamic Query

    L' Eomot Inversé (9/24/2013)

    Interesting question.

    I knew the answer, but Jens-Peter's comment made me wonder: he's quite right, the behavious is not documented on the page referenced. Nor is it...

    September 24, 2013 at 4:11 pm

    #1652916

  • RE: Dynamic Query

    So why does the question use dynamic SQL? If the focus is on how different kinds of comments relate, why not simply use:

    -- /* select 'Samith' name

    */ select 'sas'

    September 24, 2013 at 12:40 pm

    #1652865

  • RE: Reserved Words - 1

    I'm glad to see that a better reference has already been given. Saves me the trouble of looking for it.

    An interesting thing (maybe already mentioned in the discussion - I'm...

    September 19, 2013 at 12:45 pm

    #1651646

Viewing 15 posts - 1,576 through 1,590 (of 3,348 total)