Forum Replies Created

Viewing 15 posts - 31 through 45 (of 325 total)

  • RE: CASCADE - 1

    L' Eomot Inversé (3/20/2013)


    demonfox (3/20/2013)


    Danny Ocean (3/20/2013)


    Good question.

    In real life scenario, we need to take care of cascade option.

    I prefer not to have delete cascade on design .. to let...

  • RE: CASCADE - 1

    Danny Ocean (3/20/2013)


    Good question.

    In real life scenario, we need to take care of cascade option.

    I prefer not to have delete cascade on design .. to let the error display when...

  • RE: Full-Text Search – Thesaurus Languages

    presumably the "ThreeLetterISOLanguageName" property in the CultureInfo object is not actually what it is called but what MS uses (which is sometimes but not always a three letter ISO language...

  • RE: CASCADE - 1

    All that sql statemens were just for the final show 🙂

    Nice and easy !!

  • RE: Full-Text Search – Thesaurus Languages

    Hugo Kornelis (3/19/2013)


    demonfox (3/19/2013)


    These are the references I could find ..

    http://www.loc.gov/standards/iso639-2/php/code_list.php

    here is a discussion reference and an included further references .. I think, this might the standard followed by ms...

  • RE: Full-Text Search – Thesaurus Languages

    L' Eomot Inversé (3/19/2013)


    Toreador (3/19/2013)


    demonfox (3/19/2013)


    only English , when it comes to britain ...

    I'm looking forward to Tom's reply to that one 😉

    Well, just to keep Toreador happy I'll reply,...

  • RE: Full-Text Search – Thesaurus Languages

    Hugo Kornelis (3/19/2013)


    (Bob Brown) (3/19/2013)


    Hugo Kornelis (3/19/2013)


    Can anyone fill me in on the missing details?

    I don't know if this is any help but it is what I used...

  • RE: Full-Text Search – Thesaurus Languages

    L' Eomot Inversé (3/19/2013)


    Good question, but the definite cultural bias is perhaps unfortunate. I suppose it's fair enough, as the default installation will use LCID 1033, not 2057. ...

  • RE: Full-Text Search – Thesaurus Languages

    I got it right 🙂

    No reference required this time ; I got the answer since the last question posted by steve on thesaurus files 😀

    thanks for the question...

  • RE: DATETIME - 4

    Raghavendra Mudugal (3/18/2013)


    Awesome Qtod,thank you for posting.

    (I am bursting with my doubts... but no idea where to begin...)

    so to say... there will be no row/s in the datetime column where...

  • RE: DATETIME - 4

    L' Eomot Inversé (3/16/2013)


    Nice question, and fine explanation, but that bit about "59.005" seems to have come from a different than the rest. 😉

    +1

    May be, because, it's monday it...

  • RE: How to Pivot table?

    can you explain a little bit about the result set ...

    what's 14,15,16,17 ...

    on what column it is based upon ???

  • RE: Casting question

    okbangas (3/15/2013)


    Really easy question, but the explanation puzzles me. As far as I can see it is no implicit conversion, just a pure integer division.

    +1

    0.111111 being counted as 0...

  • RE: Casting question

    cheeky ...

    didn't occur a doubt on the 0 😛

    though I had a doubt over

    select isnull ( convert (char(3),1.0/9) ,'*')

    -- or

    select isnull ( convert (char(3),1/9.0) ,'*')

    and it clears out as...

  • RE: update still difficult??

    prathibha_aviator (3/14/2013)


    Thanks to every one who has been trying to help me...

    Lynn, I have to update the column with the primary key not with the identity key...

    here is the solution...I...

Viewing 15 posts - 31 through 45 (of 325 total)