Forum Replies Created

Viewing 15 posts - 61 through 75 (of 235 total)

  • RE: Cast in Varchar with different options

    rhythmk (7/16/2012)


    It is upto you if you want to learn you can use in such cases where it is hard to count the characters (exactly 30 in b option) otherwise...



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: Cast in Varchar with different options

    rhythmk (7/16/2012)


    kupy (7/16/2012)


    honza.mf (7/16/2012)


    Nice one.

    But it's very hard to count the chars early in the morning. Luckily the string in b is not 31 or 32 characters long.

    +1

    I copied the...



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: Cast in Varchar with different options

    Nice one.

    But it's very hard to count the chars early in the morning. Luckily the string in b is not 31 or 32 characters long.



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: Execs and temporary tables

    WayneS (7/6/2012)


    mtassin (7/6/2012)


    Always nice to have an easy one on Friday....

    I concur... but what is easy for one person isn't for another.

    I'm surprised, there are someone (9% now) who...



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: Execs and temporary tables

    bitbucket-25253 (7/6/2012)


    Emphasis (bolding) added by this poster

    BrainDonor (7/6/2012)


    That explanation requires expanding slightly, because there is more than one type of temporary table.

    Local temporary tables (prefixes with '#') go out...



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: Execs and temporary tables

    Thanks to everyone.

    Sorry, I missed the beggining of this discussion as I was out of civilization (holiday).



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: Execs and temporary tables

    Michael Poppers (7/6/2012)


    Thanks for the question! but the set of possible answers was "too easy": once I saw that B#2 was going to error out while B#3 was not, I...



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: Execs and temporary tables

    BrainDonor (7/6/2012)


    That explanation requires expanding slightly, because there is more than one type of temporary table.

    Local temporary tables (prefixes with '#') go out of scope when the exec command...



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: Date Conversions

    Thanks for a good and interesting question, but such horrible to read answers 🙁



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: Select Statement

    archie flockhart (5/22/2012)


    Yes, I can see a reason for having an 'integer division' operation. That doesn't mean it needed to be the default behaviour whenever two integers are divided.

    And it...



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: Select Statement

    Very easy.

    But I think there is no type conversion. 1 is int, 2 is int, the type of both operands is same and result is int.



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: Transaction isolation

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


    Yes, some education is needed in this area. The results aren't quite as bad now as when Koen saw them, but currently 27% opted for...



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: Is Computer Science Dead?

    All i really need to know i learned in the first year of programming course in the college.

    I learned little bit more next years, especially Simula 67 (3rd year).

    Technology is...



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: Tabs or Spaces

    Another point of view: Best setting is the default setting of the tool (SSMS, VS, ...). Otherwise you have inconsistencies by everyone who has forgotten to change the setting.

    And some...



    See, understand, learn, try, use efficient
    © Dr.Plch

  • RE: Tabs or Spaces

    I vote for tabs. They can be extremely rapidly shown as 3, 4, 7... spaces by configuration and they can be converted to spaces if needed.

    As I'm minority, I have...



    See, understand, learn, try, use efficient
    © Dr.Plch

Viewing 15 posts - 61 through 75 (of 235 total)