Forum Replies Created

Viewing 15 posts - 1,966 through 1,980 (of 3,348 total)

  • RE: Five percent rounded down

    The question is not bad (though I think a bit pointless; I hope people will never use this kind of data type mixing and complex ways to do simple calculations...

  • RE: Table Variables

    L' Eomot Inversé (10/19/2012)


    Actually, there's a misprint in the question (my stupid error) - it should say @ROWGUIDCOL, not ROWGUID. You can have as many rowguid columns as you...

  • RE: Table Variables

    arthur.teter (10/19/2012)


    While I know you are not supposed to be able to add multiple GUIDs to any table

    Why not? What if a table has to store foreign keys into multiple...

  • RE: Table Variables

    Very good question overall.

    Only (minor) issue - picking 6 out of 17 answer options is a task that appears daunting at first sight. The answer options were luckily well organized...

  • RE: STR

    cfradenburg (10/18/2012)


    What is the use case for the STR function? Namely, when would this be used as opposed to just doing a convert? A round can be used...

  • RE: STR

    L' Eomot Inversé (10/18/2012)


    @Cassie (10/18/2012)


    L' Eomot Inversé (10/18/2012)


    Good question

    But the explanation is very poor, inaccurate. For example the length of the expression "123.45" is 6, but str(123.45,4,2) is not...

  • RE: STR

    (It's a good thing I remember to copy my reply to the clipboard before posting it - I ran once more in the issue [probably timeout related, I always get...

  • RE: STR

    I knew about the STR function, but was not entirely sure what the optional arguments meant, so I decided to check Books Online before answering.

    I must say that I was...

  • RE: COALESCE

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


    Probably the worst explanation I've ever seen - two gross mistakes, which unfortunately cancel each other out so that people might be misled into believing them. ...

  • RE: COALESCE

    I was almost hesitant to answer the question, thinking there might be a trick thaht I was overlooking. Fortunately, I wasn't.

    The explanation is wrong, though. The innermost COALESCE does NOT...

  • RE: Noise

    okbangas (10/16/2012)


    kapil190588 (10/15/2012)


    As sql server version was not specified so I selected NoiseList but got wrong...

    I think version should be mentioned in question..

    learn new thing today.......

    If it were different in...

  • RE: VIEW - 9

    Richard Warr (10/15/2012)


    Would there also be a difference between dbo.c_view and dbo.C_view if you had case sensitive collation set?

    Yes, if your database uses case sensitive collation, "c_view" is different from...

  • RE: VIEW - 9

    At first sight, I thought this was a question to check whether indexed views can have their own statistics. I did not know that, so I set out to research...

  • RE: T-SQL

    L' Eomot Inversé (10/11/2012)


    the consequences for concurrency and performance of requiring the seed to be rolled back would be intolerable.

    That's not even the biggest issue. Consider this scenario:

    Transaction 1 starts,...

  • RE: While loop

    A.jafari (10/10/2012)


    Thanks For Answer, sorry "Try Except" is wrong ,it is Commad Of Delphi ,

    ,i Want to say Diffrent Bettween "Begin Tran" And "Begin Catch"

    BEGIN TRAN .......

Viewing 15 posts - 1,966 through 1,980 (of 3,348 total)