Forum Replies Created

Viewing 15 posts - 46 through 60 (of 521 total)

  • RE: CHOOSE - 1

    bitbucket-25253 (1/29/2013)

    davoscollective

    A lot of people are complaining about not having SQL Server 2012 or Adventureworks on production machines. I have a test/dev VM with SQL Server 2012 SP1 and both...

    January 29, 2013 at 8:01 am

    #1582153

  • RE: CHOOSE - 1

    mtassin (1/28/2013)

    Christian Buettner-167247 (1/28/2013)

    Don't have AdventureWorks either... 🙁

    You know, google and 5 minutes of download time and you can get it... MS puts it up on Codeplex for you

    Thank you...

    January 29, 2013 at 12:51 am

    #1581916

  • RE: CHOOSE - 1

    Don't have AdventureWorks either... 🙁

    January 28, 2013 at 2:30 am

    #1581483

  • RE: UNIQUE constraint

    Oh my, why is this question still wrong in January?!? 🙁

    January 11, 2013 at 1:20 am

    #1576099

  • RE: Divide by zero

    Hugo Kornelis (12/23/2012)

    While hunting for this information, I did find a few Connect items about errors with WHEN (something that's never true) THEN MIN(1/0) or WHEN (something that's always true)...

    January 10, 2013 at 3:12 am

    #1575675

  • RE: Santa's List

    OK, I hate to start nitpicking, but the correct answer is missing:

    For 7 rows you definitively need NO index to improve performance 😛

    January 10, 2013 at 1:51 am

    #1575647

  • RE: TSQL 2012 #1

    I too would have liked an explanation for the purpose of "FOR BROWSE" in relation to that DMV.

    At the moment the new "knowledge" about this DMV is useless, without knowing...

    January 10, 2013 at 1:35 am

    #1575632

  • RE: PARSE 1

    L' Eomot Inversé (12/17/2012)

    Mosty a good question, apart from the awful misprint - the table would not be created unless that was corrected!

    To all those talking about select being atomic:...

    December 17, 2012 at 5:57 am

    #1569106

  • RE: PARSE 1

    JoseACJr (12/17/2012)

    Hi,

    Select #2 Returns 2 rows ???

    I don´t think so..

    Error converting string value '2013DEC32 00:00:00' into data type datetime using culture ''.

    I was also quite surprised to see this answer...

    December 17, 2012 at 3:31 am

    #1569082

  • RE: Thanksgiving 2012

    Good question, but the explanation is not helpful... Where is the BOL link for this?!?

    I don't want mess up dinner because the function doesn't work as expected...

    November 22, 2012 at 1:38 am

    #1561514

  • RE: COALESCE - 2

    Raghavendra Mudugal (11/9/2012)

    Msg 4127, Level 16, State 1, Line 8

    At least one of the arguments to COALESCE must be an expression that is not the NULL constant.

    .. possibly just missing...

    November 9, 2012 at 4:55 am

    #1557560

  • RE: COALESCE - 2

    Good question, but wrong explanation (and also wrong error message from SQL Server):

    The coalesce expects at least one typed NULL in order to execute and hence the error.

    Simple example that...

    November 9, 2012 at 1:48 am

    #1557491

  • RE: Enable Database Mail in 2012

    It would be new to me that sp_configure is an extended stored procedure.

    I think it is just a normal system stored procedure.

    But still a good question:)

    November 7, 2012 at 1:12 am

    #1556657

  • RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

    Lisa Slater Nicholls (9/14/2012)

    ronmoses (9/14/2012)

    Rather than parsing the string, how about attempting to CAST the string in a TRY...CATCH block and return a pass/fail value on that basis?

    ron

    The problem here...

    September 17, 2012 at 1:52 am

    #1538428

  • RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

    I think this "could" be solved using a CLR function that tries to cast the value to each acceptable numeric data type, but I never did CLR.

    Unfortunately you cannot do...

    September 14, 2012 at 2:27 am

    #1537679

Viewing 15 posts - 46 through 60 (of 521 total)