Forum Replies Created

Viewing 15 posts - 511 through 525 (of 656 total)

  • RE: The Percent Sign in T-SQL

    SanDroid (2/28/2011)

    So happy that over 80 percent of us know math.

    Can you imagine how hard it would be a SQL developer or DBA if you didn't learn higher level math?

    What's...

    March 1, 2011 at 2:25 am

    #1292762

  • RE: Connection Problems

    sp_helptext[sp_change_users_login] will reveal all 🙂

    February 7, 2011 at 2:27 am

    #1282994

  • RE: Connection Problems

    I always use sp_change_users_login in these circumstances, so had to pick an answer at random, luckily I got the right one :).

    I wonder why they are withrawing this procedure? Anyone...

    February 7, 2011 at 2:15 am

    #1282990

  • RE: Fun(?) with DATETIME2

    Brandie Tarvin (2/4/2011)

    The trick is that date doesn't actually exist in some countries, including the U.S.

    But given that the date does exist in many other countries, SQLServer is completely right...

    February 4, 2011 at 10:12 am

    #1282565

  • RE: Standard Deviation

    Koen (da-zero) (1/28/2011)

    Then why is the explanation confusing? I find it pretty clear...

    The explanation is "The denominator of the variance for a sample population is n - 1, resulting in...

    January 28, 2011 at 3:01 am

    #1279591

  • RE: CONVERT function

    You mean I was supposed to read all the words in your reply?!

    January 13, 2011 at 6:38 am

    #1272986

  • RE: CONVERT function

    I use the one that is invoked by pressing F1 in SSMS

    ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/a87d0850-c670-4720-9ad5-6f5a22343ea8.htm#seeAlsoSection

    No links that I can see. Maybe I'll switch to using the interweb version.

    January 13, 2011 at 4:17 am

    #1272938

  • RE: CONVERT function

    Hugo Kornelis (1/13/2011)

    And most online BOL pages include cross-links to earlier and/or later versions of the same topic.

    The SQl2008 "Cast and Convert" topic doesn't ;(

    January 13, 2011 at 3:58 am

    #1272927

  • RE: CONVERT function

    Didn't know what the style values were for varchar conversions so looked it up in BOL. Puzzled out the rather confusing description, and duly got it wrong, as there's nothing...

    January 13, 2011 at 3:23 am

    #1272901

  • RE: ANSI Padding

    Christian Buettner-167247 (1/11/2011)

    SQL Server 2000 is not unsupported. Only the mainstream support has ended.

    So it's supported, but only if we pay for it.

    In my book, that means it's unsupported 😉

    January 11, 2011 at 3:22 am

    #1271773

  • RE: ANSI Padding

    Not a terribly useful question IMHO. OK, so you might inherit some legacy code, but hopefully most of us don't use any of the 'non-ansii' options any more for new...

    January 11, 2011 at 2:14 am

    #1271755

  • RE: T-SQL

    WayneS (1/4/2011)

    I think that it's upon the QotD authors to attempt to write their questions to apply to as many versions of sql as possible (obviously, when writing about features...

    January 4, 2011 at 7:49 am

    #1268967

  • RE: smalldatetime

    "Whenever we use any data type we should know it's default value"

    I disagree (even ignoring the valid but slightly pedantic points about datatypes not having defaults).

    We should never rely on...

    January 4, 2011 at 3:15 am

    #1268830

  • RE: Fun(?) with DATETIME2

    David Data (12/27/2010)

    I wonder if anyone has created a nation-sensitive historic date system in which [font="Courier New"]Date('1752-09-02') + 1[/font] would give the correct result depending on country. e.g. [font="Courier New"]'1752-09-13'[/font]...

    January 4, 2011 at 2:50 am

    #1268822

  • RE: Subtle Line Feed / Carriage Return issue

    Rune Bivrin (12/23/2010)

    While I find the question slightly pointless, I have to say I'm more than a little surprised that so many got it wrong. The question made it perfectly...

    December 24, 2010 at 2:11 am

    #1266156

Viewing 15 posts - 511 through 525 (of 656 total)