Forum Replies Created

Viewing 15 posts - 61 through 75 (of 234 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...

  • 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...

  • 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.

  • 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...

  • 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...

  • RE: Execs and temporary tables

    Thanks to everyone.

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

  • 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...

  • 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...

  • RE: Date Conversions

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

  • 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...

  • 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.

  • 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...

  • 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...

  • 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...

  • 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...

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