Forum Replies Created

Viewing 15 posts - 211 through 225 (of 326 total)

  • RE: Noise

    Keeping the title as noise ; kool ...

    stoplists; I wasn't sure of the nomenclature but I got that correct after reading an article ...

    nice to learn something.

    thanks for the question

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    October 15, 2012 at 10:56 pm

    #1549370

  • RE: VIEW - 9

    nice question ..

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    October 14, 2012 at 11:36 pm

    #1548988

  • RE: While loop 2

    Lokesh Vij (10/11/2012)

    Thanks Sreenivas for the question. Indeed we discussed the situation of "Divide by zero error" in your earlier QOTD discussion forum "While Loop - 1".

    All in all ending...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    October 12, 2012 at 2:53 am

    #1548501

  • RE: Appropriate Data Type

    Eugene Elutin (10/11/2012)

    Float is a very bad choice for monetary values as it's approximate numeric.

    I would recommend Decimal which is precise (exact numeric).

    You can use Money too, if you brave...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    October 11, 2012 at 5:25 am

    #1548021

  • RE: T-SQL

    Lokesh Vij (10/10/2012)

    bitbucket-25253 (10/10/2012)

    Nice simple question on the basics. Every one should get this right (I hope)

    I was hoping this too....Not every one got it correct!

    Correct answers: 75% (9)

    Incorrect...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    October 10, 2012 at 10:24 pm

    #1547878

  • RE: Update records?

    khushbu (10/9/2012)

    I have been hearing lately that SQL Server when performing update to any table, first deletes that set of records and then inserts the record with the new value.

    Wonder...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    October 10, 2012 at 2:34 am

    #1547523

  • RE: While loop

    Lokesh Vij (10/9/2012)

    demonfox (10/9/2012)

    well, instead of 10/0.00001 try using 10/0 , guess what the answer could be 😀

    Initially I thought this division is the key to answer this question; as...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    October 10, 2012 at 2:29 am

    #1547518

  • RE: While loop

    yes, nice question; try and catch doesn't hold anything.. even if you put the above code in a transaction it would still give 11.

    well, instead of 10/0.00001 try using 10/0...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    October 9, 2012 at 10:20 pm

    #1547443

  • RE: View - 8

    good question..

    nice and easy ..

    Thanks

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    October 7, 2012 at 10:11 pm

    #1546555

  • RE: insert statements - multiple

    Ya i faced the same issue while creating a one time script . Since it was meant for another team , so I just had it executed in 5000 records...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    October 5, 2012 at 10:25 pm

    #1546380

  • RE: XML adding

    Just and example:

    declare @var int = 40

    DECLARE @XML XML='<ROOT>

    <ITEMS PID="0" FN="DEFAULT " LN="DEFAULT" />

    <ITEMS PID="1" FN="HARISH" LN="SINGH" />

    </ROOT>'

    SELECT @XML

    SET @XML.modify(' ...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    October 5, 2012 at 9:47 pm

    #1546372

  • RE: SELECT

    (Bob Brown) (10/5/2012)

    bitbucket-25253 (10/5/2012)

    Hugo Kornelis (10/5/2012)

    kyliedude (10/5/2012)

    Give me my point!

    If points are that important for you, you can have one of mine. Heck, you can have all of...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    October 5, 2012 at 1:23 pm

    #1546300

  • RE: SELECT

    mccork (10/4/2012)

    Lokesh Vij (10/4/2012)

    sam.dahl (10/4/2012)

    I recognised the attempt to insert null and hence picked 2,0 because that's what the two select statements return: 2 and 0. It's the insert statement...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    October 5, 2012 at 12:08 am

    #1545902

  • RE: SELECT

    Lokesh Vij (10/4/2012)

    sam.dahl (10/4/2012)

    I recognised the attempt to insert null and hence picked 2,0 because that's what the two select statements return: 2 and 0. It's the insert statement that...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    October 4, 2012 at 10:08 pm

    #1545882

  • RE: FTS

    nice and easy ..

    thanks for the question.

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    October 4, 2012 at 2:43 am

    #1545389

Viewing 15 posts - 211 through 225 (of 326 total)