Forum Replies Created

Viewing 8 posts - 1 through 8 (of 8 total)

  • RE: No R2

    I suspect that the versioning will have to do with CALs and how most folks license the products:

    - Windows Server requires CALs to licenses, and as I understand it, a...

  • RE: Update with CASE statement

    I enjoyed the question. Keep up the work in writing them (I can never seem to come up with a good question idea myself...)

    As for writing the question, I...

  • RE: Update with CASE statement

    Vel.Velez (2/19/2013)


    In SQL Server 2005, wouldn't this FAIL?

    --#2 Data

    INSERT INTO GenderUpdate (Gender)

    VALUES ('M'), ('M'),('M'),('M'),('M'),('M'),('F'),('F'),('F'),('F'),('F'),('F'),('F'),('F'),('F'),('F')

    If so, #4 would not get to execute?

    Correct - checking my results, my default instance is...

  • RE: BIT Primary Key

    Good Question!

    Although the "conversion" of a number to either a 1 or a 0 bit - I did appreciate the "look at the most significant bit - if it's 1...

  • RE: LIKE a vowel

    At first I was a little miffed about missing the question - especially since there wasn't a hard reference.

    Then after reading the discussions and experimenting with Thorn and...

  • RE: LIKE a vowel

    Another two that could come up are:

    Þ - the archaic letter thorn - which will come up with 'th' in the select.

    ß - the German "Sharp S" - which...

  • RE: The Maintenance Poll

    Being a small company, I have a little more flexibility in scheduling, as long as our primary web and mail servers are operational during our employees' work hours. Most...

  • RE: Read Uncommitted, locks, and transactions

    I'll add another "Great Question" - I like the questions that make you sit and think about an answer, rather than either run a snippet of code or look up...

Viewing 8 posts - 1 through 8 (of 8 total)