Forum Replies Created

Viewing 15 posts - 1,906 through 1,920 (of 7,484 total)

  • RE: Don’t Understand? You’re About to Learn Something

    Andy Warren (3/9/2015)


    Gary, I don't any experience with Eastern culture, but what you say fits my impressions from what I've read about it here and there, I had not considered...

  • RE: Identity Column Datatype

    RLilj33 (3/9/2015)


    This one threw me off. Can someone explain BOL (https://msdn.microsoft.com/en-us/library/ms189838.aspx):

    "data_type

    Is the data type of the identity column. Valid data types for an identity column are any data types...

  • RE: Why this error when inserting to text type field

    This is a duplicate of your post http://www.sqlservercentral.com/Forums/FindPost1666510.aspx'.

    The answer is in that thread.

  • RE: Mortgage amortization table

    Jeff Moden (3/1/2015)


    Solomon Rutzky (3/1/2015)


    Interestingly enough, nearly all of them were wrong in the exact same way. They all did their rounding at the presentation layer.

    I'm not so sure that's...

  • RE: EXCEL HELL!!!

    Jeff Moden (3/2/2015)


    sqldriver (3/2/2015)


    This is a great day! I get to tell people I'm as good at something in SQL as Jeff Moden, even if it is SSIS. 😀

    😀

    I'll never...

  • RE: Why this error message..... Operand type clash: varbinary is incompatible with text

    mw112009 (3/8/2015)


    The field conclusions is of type text

    insert into ACRC_443_ECHO_DATA_Event_Echo ( conclusions )

    VALUES

    (0x4e6f207468726f6d627573206f722073706f6e74616e656f757320636f6e747261737420696e206c6566742061747269756d2f6c6566742061747269616c20617070656e646167652e0d0a4e6f206c65667420746f20726967687420636f6c6f7220666c6f77206163726f737320696e74657261747269616c2073657074756d2e0d0a53746174757320706f7374206d697472616c2076616c7665207265706169722e );

    Why do I get this error:

    Msg 206, Level 16, State 2, Line...

  • RE: Identity Column Datatype

    This is a rather early repeat! We had an identical question on Jan 13th, less than 2 months ago; and then on Jan 20th we had another question for...

  • RE: What is the equivalent to Yes/No data type in SQL?

    CELKO (3/4/2015)


    I did like the article basically promoting thinking things out at design time to see if the state you want to represent with a BIT data type is truly...

  • RE: Creating schemas

    Raghavendra Mudugal (3/3/2015)


    djj (3/3/2015)


    I guessed correctly, however, how does this prevent the user from creating in other schemas? Is it because he has not been given permission explicitly to...

  • RE: BREAK

    sknox (3/4/2015)


    archie flockhart (3/4/2015)


    Curious as to why the Break doesn't exit from the IF , as the referenced BOL page suggests that it should ? ( It clearly does work...

  • RE: BREAK

    archie flockhart (3/4/2015)


    Curious as to why the Break doesn't exit from the IF , as the referenced BOL page suggests that it should ? ( It clearly does work as...

  • RE: What is the equivalent to Yes/No data type in SQL?

    Jeff Moden (3/3/2015)


    CELKO (3/3/2015)


    While what you say is absolutely true, there are so many nice ways to say this and so many ways to make this useful and you...

  • RE: Today's Random Word!

    Revenant (3/2/2015)


    whereisSQL? (3/2/2015)


    djj (3/2/2015)


    Lynn Pettis (3/2/2015)


    HOME

    Heart

    CardioThorasic

    Trouble

    Tribbles

  • RE: Premature casting on 0 rows insert

    ScottPletcher (3/2/2015)


    Codd was working for IBM at the time, and IBM asked him to do it. To be fair, a lot of it was not just "ill-conceived". Computers...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (3/2/2015)


    But still, I feel like jumping in the ocean and swimming over to Europe to escape the embarrassment.

    Don't do that - you just get wet and tired. ...

Viewing 15 posts - 1,906 through 1,920 (of 7,484 total)