Forum Replies Created

Viewing 15 posts - 256 through 270 (of 658 total)

  • RE: TSQL- XQuery

    matthew.flower (7/29/2013)


    <a> is obviously a complex element because it contains <c> and <d>, so it can't contain "1".

    Where did you get that idea from? It's perfectly valid.

  • RE: TSQL- XQuery

    Koen Verbeeck (7/28/2013)


    Tsk tsk, first question of the week, and it's about XQuery (ugh). And even a trick question (double ugh).

    It's not really about XQuery though, it's a trick question...

  • RE: A New Look

    Jeff Moden (7/28/2013)


    Hooray! The "old look" is back! 🙂

    I get the same narrow strip of text, only it's now left justified, and the right 2/3 of the screen...

  • RE: A New Look

    http://www.sqlservercentral.com/articles/SQLServerCentral/100393 requested that comments be made in this discussion.

  • RE: A New Look

    If nothing else it would be nice to have a reply addressing people's concerns, and if there is no intention of changing anything then maybe explaining why?

  • RE: A New Look

    david.wright-948385 (7/24/2013)


    Henk Schreij (7/24/2013)


    The next disaster has struck.

    Since July 17, the QOD (question of the day) has no "yesterday's answer" anymore. Why? :crying:

    Please "consult" the responsible manager for these changes.

    +1

    +...

  • RE: T-SQL

    L' Eomot Inversé (7/22/2013)

    And it's terrifying that more than a third of people get this wrong, because that suggests that there is rather a lot of SQL out there that...

  • RE: T-SQL

    PRR.DB (7/22/2013)


    If table doesn't have clustered index , there is no guarantee for order , if table having clustered index then result will display clustered index column order.

    Is my...

  • RE: What's in a name?

    So with SQL2012 it's called SSDT, but for SQL2014, which isn't out yet, it's called SSDTBI? Or is that over-simplifying 😉

  • RE: What will convert return?

    Kingston Dhasian (7/11/2013)


    The explanation is not completely correct

    Worse than that, the explanation is completely incorrect 🙁

    It gives two "facts" (that this number exceeds the upper limit of an integer, and...

  • RE: The US Holiday

    The case-sensitive date format in SQL2000 causes all text to be displayed in yellow on an orange background, so I demand that my points are given back with extra as...

  • RE: A New Look

    On my screen, approximately 2/3 of the width is white. Why all the wasted space? I don't do my development on a mobile device, and don't read this website on...

  • RE: Between Clause

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


    I have seen far more order comparisons on strings than on numbers. I agree there is no need for using BETWEEN on strings - but there's...

  • RE: Date add with Different DataType

    Hugo Kornelis (6/21/2013)


    Can you provide a source for that?

    yes - my faulty memory 😉

  • RE: Date add with Different DataType

    Hugo Kornelis (6/21/2013)The only reason that this ends up returning the next day is because of how datetime is internally implemented.

    I thought that the main reason it returns the next...

Viewing 15 posts - 256 through 270 (of 658 total)